mysql根据用自己的邀请码查询该用户所有下级

最新推荐文章于 2023-09-12 21:15:01 发布

转载最新推荐文章于 2023-09-12 21:15:01 发布 · 714 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/fanqie15/p/11066064.html

文章标签：

#数据库 #php

博客展示了一段SQL查询代码，通过多表连接和嵌套查询，从customer和customer_member表中筛选出与特定邀请码相关的数据，并按id升序排序。代码涉及复杂的表关联和条件判断，用于数据库数据的精准查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
c.id,
c.pid,c.zid,
c.self_invite,m.level_define
from customer_member m,
(
SELECT
id,
pid,zid,
self_invite
FROM
(
SELECT
a1.id,a1.zid,
a1.invite_code pid,
a1.self_invite,
a2.invite_code p2id,
a3.invite_code p3id,
a4.invite_code p4id,
a5.invite_code p5id
FROM
customer a1
LEFT JOIN customer a2 ON (
a1.invite_code = a2.self_invite
)
LEFT JOIN customer a3 ON (
a2.invite_code = a3.self_invite
)
LEFT JOIN customer a4 ON (
a3.invite_code = a4.self_invite
)
LEFT JOIN customer a5 ON (
a4.invite_code = a5.self_invite
)
) al
WHERE
(
pid = 'AUTYPM'
OR p2id = 'AUTYPM'
OR p3id = 'AUTYPM'
OR p4id = 'AUTYPM'
OR p5id = 'AUTYPM'
) ) c WHERE m.cust_id = c.zid order by id ASC