How to properly store related products?

Question

MySQL

I have an entity Product. The product can be a normal product, or it can be one that is not visible anywhere except for the "You will also like" block (i.e. it can only be shown in this block, and nowhere else ).
I store it like this:
products
id
name
...
product_type_id
product_types
id
name (Regular Product, Related Product) - only shows up in the admin
, am I storing it right? I also have an option to create a table of related products with a single column product_id, all products that are stored there are considered related. Which option to choose, the first or the second?)

Answer 1

I would make a product table and a separate link table where I would store product_id, extra_product_id