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

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

# 'AUTYPM'是该用户自己的邀请码