There is a table
list structure
Id,name,description,parent_id
There are multiple sub-classifications under one classification, and there will be sub-classifications under each sub-classification, with a depth of about 10 layers.
The arrangement of classifications is also irregular, and the desired results are as follows:
Fruits
- Domestic fruit
- Northern region
- Liaoning province
- Shandong
….
- Southern region
- Hunan
….
- Hunan
- Northern region
- Imported fruit
…. - Boutique gift box
….
…
It is better not to use recursion in this infinite classification.
There is a more efficient scheme (left value and right value scheme) for the classification information with little change in the tree type itself:
http://ftp.nchu.edu.tw/MySQL/tech-resources/articles/hierarchical-data.html