无限级分销系统查自己上级、下级之多叉树实现关系速查

select uid,name,puid,level,ppuid,rootuid,uleft,uright from qx_user_ppp WHERE rootuid = 1

ORDER BY uleft

2

2

3

3

4

7

8

7

9

4