mysql根据用户的邀请码查询该用户所有的上级

SELECT
T1.lvl AS 'level',
T2.id AS 'id',
T2.zid AS 'zid',
T2.self_invite AS 'selfInvite',
T2.invite_code AS 'inviteCode',
TM.level_define,
TM.putong_num,
TM.vip_num,
TM.zhuguan_num,
TM.jingli_num,
TM.team_num
FROM
(
SELECT
@child AS _self_invite,
(
SELECT
@child := invite_code
FROM
customer
WHERE
self_invite = _self_invite
) AS p,
@l := @l + 1 AS lvl
FROM
(
SELECT
@child := 'EJFFZXAI',
@l := 0
) vars,
customer h
WHERE
@child <> ''
) T1,
customer T2,
customer_member_team TM
WHERE
T1._self_invite = T2.self_invite
AND TM.cust_id = T2.zid
ORDER BY
T1.lvl DESC

# 'EJFFZXAI'是该用户被邀请的邀请码，即该用户上级自己的邀请码

转载于:https://www.cnblogs.com/fanqie15/p/11065702.html