MySQL中查询一个深度为3的树
SQL server转为MySQL 时with as语法不能用问题
sys_depart 表:id,父级ID:parent_id
有县镇村三级
SELECT DISTINCT d.id,d.depart_name
FROM sys_depart a
INNER JOIN sys_depart b ON a.id = b.parent_id OR a.id = b.id
INNER JOIN sys_depart c ON b.id = c.parent_id OR b.id = c.id
INNER JOIN sys_depart d ON c.id = c.parent_id OR c.id = d.id
WHERE a.id = '3b71f4fd6d4e4c5c943386b26cb581f8'