javawebliu66的博客

SELECT T2.id, T2.name FROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM t_department WHERE id = _id) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := #{id}, @l := 0) vars, t_smart_cr..