How is the organization of the online store catalog implemented?

Question

Database design

I'm making a store in yii2. I would like to know the opinion of experienced people on how to properly organize the catalog of an online store. Those. how it should be composed: it is one table, a tree or several related tables for storing categories, subcategories and products (names)

Answer 1

Tree, in the simplest case id, pid, name. More complicated nested set.
The product has a category_id field where the main category is placed and an additional product-category table if the product can be in several categories