with cte as

(

select IDPlus,SuperiorsIDPlus,RoleGrade,viplevel,NAME,WeixinId from Member

where IDPlus = 2999

union all

select d.IDPlus,d.SuperiorsIDPlus,d.RoleGrade,d.viplevel,d.NAME,d.WeixinId from cte c inner join Member d

on c.SuperiorsIDPlus = d.IDPlus

)

select * from cte