php 查询所有上级

最新推荐文章于 2023-10-27 13:21:58 发布

原创最新推荐文章于 2023-10-27 13:21:58 发布 · 3.1k 阅读

2 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

18 篇文章

订阅专栏

查询所有的父类

 "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