mysql之上二级 Mysql

#获取会员的上二级
drop view if exists vwMemberL2Parent;

create view vwMemberL2Parent 
as
select m.id,
　　　　m.parent_id,
　　　　m.nickname,
　　　　m.realname,
　　　　m.avatar,
　　　　m.mobile,
　　　　m.invite_merch_id,
　　　　L2.nickname as L2nickname,
　　　　L2.realname as L2realname,
　　　　L2.avatar as L2avatar,
　　　　L2.mobile as L2mobile
from `ims_tycb_xyl_member` as m 
LEFT JOIN `ims_tycb_xyl_member` as L1 on m.parent_id = L1.id
LEFT JOIN `ims_tycb_xyl_member` as L2 on L1.parent_id = L2.id

 

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄