MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE products (id INT, name VARCHAR(20))
CREATE TABLE options (id INT, name VARCHAR(20))
CREATE TABLE product_options (id INT, product_id INT, option_id INT)
INSERT INTO products VALUES (1, 'Product 1'),(2, 'Product 2'),(3, 'Product 3')

Records: 3  Duplicates: 0  Warnings: 0


INSERT INTO options VALUES (1, 'Option 1'), (2, 'Option 2'), (3, 'Option 3'), 
(4, 'Option 4'), (5, 'Option 5')

Records: 5  Duplicates: 0  Warnings: 0


INSERT INTO product_options VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 2, 2),
(5, 2, 3),
(6, 2, 4),
(7, 3, 3),
(8, 3, 4),
(9, 3, 5)

Records: 9  Duplicates: 0  Warnings: 0


CREATE PROCEDURE display_options()
BEGIN
  SET @query = 'SELECT p.name, ';
  SET @query = CONCAT(@query, (SELECT GROUP_CONCAT(CONCAT('MAX(CASE WHEN o.name = ''', name, ''' THEN o.name END) AS `', name, '`')) FROM options ORDER BY id));
  SET @query = CONCAT_WS(' ', @query, 
                         'FROM products p',
                         'JOIN product_options po ON po.product_id = p.id',
                         'JOIN options o ON o.id = po.option_id',
                         'GROUP BY p.name');
  PREPARE stmt FROM @query;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
END
CALL display_options()


name
Option 1
Option 2
Option 3
Option 4
Option 5


Product 1
Option 1
Option 2
Option 3
null
null

Product 2
null
Option 2
Option 3
Option 4
null

Product 3
null
null
Option 3
Option 4
Option 5

name	Option 1	Option 2	Option 3	Option 4	Option 5
Product 1	Option 1	Option 2	Option 3	null	null
Product 2	null	Option 2	Option 3	Option 4	null
Product 3	null	null	Option 3	Option 4	Option 5