mysql 嵌套表_mysql中部门表的自我嵌套查询

SELECT

t1.id,t1.deptName,

t2.id,t2.parentDept,t2.deptName,

t3.id,t3.parentDept,t3.deptName,

t4.id,t4.parentDept,t4.deptName,

t5.id,t5.parentDept,t5.deptName,

t6.id,t6.parentDept,t6.deptName,

t7.id,t7.parentDept,t7.deptName

FROM users_t_department t1

LEFT JOIN users_t_department t2 ON t1.id = t2.parentDept

LEFT JOIN users_t_department t3 ON t2.id = t3.parentDept

LEFT JOIN users_t_department t4 ON t3.id = t4.parentDept

LEFT JOIN users_t_department t5 ON t4.id = t5.parentDept

LEFT JOIN users_t_department t6 ON t5.id = t6.parentDept

LEFT JOIN users_t_department t7 ON t6.id = t7.parentDept

WHERE 1=1

and t1.id = "cab0212f-9d1e-4c8d-8a7f-ae1ac51701ce"