Mysql 查询子节点所有的父节点

SELECT
@r AS _id,
(SELECT @r := parent_id FROM sys_dept WHERE id = _id) AS parent_id,
@l := @l + 1 AS lvl FROM (SELECT @r := 子节点ID, @l := 0) vars,
sys_dept h WHERE @r <> 0 AND parent_id > 0