mysql 查找会员上级_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'是该用户被邀请的邀请码，即该用户上级自己的邀请码