sql语句,根据id查询所有子级,包括当前父级(无限层级)
sql语句,根据id查询所有子级,包括当前父级(无限层级)WITH RECURSIVE locs(id,pid,name)AS(SELECT a.id,a.pid,a.name,0 AS loclevel FROM user awhere a.id='47dbe7d9-96bf-414e-b318-cb288b0f381b'UNION ALLSELECT a.id,a.pid,a.name,loclevel+1 FROM user aINNER JOIN locs p ON a.pid
原创
2020-07-17 09:34:14 ·
2713 阅读 ·
0 评论