php 查询所有上级

查询所有的父类

 "SELECT T2.id, T2.username,T2.status ,T2.openid,T2.credit ,T2.gold,T2.gx_tree FROM (   
            SELECT  @r AS _id,  (SELECT @r := pid FROM ".table('user')." WHERE id = _id) AS pid,   
            @l := @l + 1 AS lvl   FROM    (SELECT @r := ".$_SESSION['account']['id']." , @l := 0) vars,   
            ".table('user')." h   WHERE @r <> 0) T1 JOIN ".table('user')." T2   ON T1._id = T2.id  ORDER BY T1.lvl ASC