SELECT p.id,p.name,p.parent_id,p.path,p.level,p.created,p.updated,
c.id c_id,c.name c_name,c.parent_id c_parent_id,c.path c_path,
c.level c_level,c.created c_created,c.updated c_updated
FROM
(SELECT *FROM rights WHERE parent_id=0) p
LEFT JOIN
rights c
ON
p.id=c.parent_id
查询父级目录下的子级目录
最新推荐文章于 2023-05-12 15:15:49 发布