mysql–遍历查询父节点
sys_dept 这个换成自己的表名
字段说明:dept_id:数据ID , pid :父节点ID ; simple_name 名称 (这三个字段更改成自己的字段既可)
SELECT T2.dept_id, T2.simple_name
FROM (
SELECT
@r AS _id,
(SELECT @r := pid FROM sys_dept WHERE dept_id = _id) AS parent_id
FROM
(SELECT @r := 498, @l := 0) vars, #查询id为5的所有上级
sys_dept h
WHERE @r <> 0) T1
JOIN sys_dept T2
ON T1._id = T2.dept_id
order by dept_id