mysql 查询三级或多级用户数量

select count(*) where fid=2

union

select count(*) where fid in select id where fid = 2

union

select count(*) where fid in select id where fid in select id where fid = 2

具体语法记不清了，差不多就是这种结构的

mysql

1

select 1.lid,1.lname,GROUP_CONCAT(2.sname) from 1 left join 2 on 2.lid=1.lid

oracle

1

select 1.lid,1.lname,WM_CONCAT(2.sname) from 1 left join 2 on 2.lid=1.lid

---