56,940
社区成员




mysql> select * from t_yifanwu;
+------+-----------+-------+
| id | parent_id | value |
+------+-----------+-------+
| 1 | 0 | 0 |
| 2 | 0 | 0 |
| 3 | 1 | 1 |
| 4 | 2 | 1 |
| 5 | 1 | 2 |
+------+-----------+-------+
5 rows in set (0.03 sec)
mysql> select id
-> from t_yifanwu
-> order by if(parent_id=0,id,parent_id),parent_id,value desc;
+------+
| id |
+------+
| 1 |
| 5 |
| 3 |
| 2 |
| 4 |
+------+
5 rows in set (0.00 sec)
mysql>