php - How to design a database similar to the top three levels of navigation on Apple's official website?

Question

Mac/iPad/iPhone...First-level navigation

iPad Pro/ipad/iOS 10...Secondary Navigation

Overview/Technical Specifications/Buy Button...Three Level Navigation

How should the database be designed? How are the PHP code layers assembled?

Answer 1

Create a product category table and a model table information table.
Mac/iPad/iPhone...the first-level navigation is stored in the product category table
iPad Pro/ipad/iOS 10...the second-level navigation is stored in the model information table

When querying, you only need to query the category as the first-level navigation.
Query the model information table as the second-level navigation and information.

Answer 2

Thanks for the invitation!

If you just want to deal with the correspondence between level 1, 2, and 3 categories, you only need one table, and add two fields parent_id (parent class ID) and child_id (child class ID) to the table