Sonraki yapısı ile bir menü yapmak çalışıyorum Im:

-category 1
--category 1.1
---category 1.1.1
----product 1
----product 2
----product 3
-category 2
--category 2.1
---category 2.1.1
----product 1
----product 2
----product 3
-category 3
--category 3.1
---category 3.1.1
----product 1

Ben wordpress gibi bir planı var:

relation_category_products table store an id from category and id from products. The question is whats the best way to make the mysql queries for having all that structure? My first solution it was make queries for parent category (-category), then for each every row take the id for the next --category and then until raise the product node. But with that tecnique theres a lot of queries (35 for the moment). And i dont know whats the better way to get all that relationship and take it with php for render the menu.

teşekkürler