mysql 获取树形结构

SELECT T2.id, T2.name ,T2.rebate_Percent,T2.Usr_Type

FROM (

    SELECT

       @r AS _id,

       (SELECT @r := parent_id FROM admins WHERE id = _id) AS parent_id,

        @l := @l + 1 AS lvl

    FROM

        (SELECT @r :=1418  , @l := 0) vars,

        admins h

    WHERE @r <> 0) T1

JOIN admins  T2

ON T1._id = T2.id

ORDER BY T1.lvl DESC