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.
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
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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.
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