表结构如下:
id | tinyint(4) |
| |
label | varchar(100) | latin1_swedish_ci | |
parent | tinyint(4) |
|
部分数据:
2 | Company | 0 | |
3 | Media Center | 0 | |
4 | Your Account | 0 | |
5 | Community | 0 | |
6 | For Content Publishers | 1 | |
7 | For Small Businesses | 1 | |
8 | Background | 2 |
SQL语句:
select t.label, t.parent, t2.id as child from tree t inner join tree t2 on t.id = t2.parent where t.id = 2