mysql 查询省市区树状结构

SELECT

t1.dept_id, t1.NAME, t1.pid, t1.sub_count, t1.enabled

FROM sys_dept t1

LEFT JOIN sys_dept t2 ON t1.pid = t2.dept_id

LEFT JOIN sys_dept t3 ON t2.pid = t3.dept_id

LEFT JOIN sys_dept t4 ON t3.pid = t4.dept_id

WHERE

t1.pid = 6129870 OR t2.dept_id = 6129870 OR t3.dept_id = 6129870 OR t4.dept_id = 6129870

GROUP BY t1.dept_id, t1.NAME, t1.pid, t1.sub_count, t1.enabled

ORDER BY t1.NAME, t1.pid DESC;