MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
set @@sql_mode = ''
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')
INSERT INTO options VALUES (1, 'Option 1'), (2, 'Option 2'), (3, 'Option 3'), 
(4, 'Option 4'), (5, 'Option 5')
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)
SELECT  CONCAT(p.productName, ",", GROUP_CONCAT(COALESCE(IF(p.optionId IN (product_options.option_id),p.optionName,NULL),"NULL") order by p.optionId)) AS result
FROM product_options
RIGHT JOIN (SELECT products.id as productId,  products.name as productName,options.id as optionId, options.name AS optionName from products,options) 
as p On p.productId = product_options.product_id AND p.optionId = product_options.option_id
GROUP BY p.optionId


result


Product 1,NULL,NULL,Option 1

Product 2,Option 2,NULL,Option 2

Product 2,Option 3,Option 3,Option 3

Product 1,Option 4,Option 4,NULL

Product 1,Option 5,NULL,NULL