通过子级查询父级

with cte as
(
select * from Member where LoginName='shop1'   //子级名称
union all
select a.* from Member a join cte b on a.LoginName=b.recommend
)
select * from cte  order by Createtime

select * from Member

 

with ds as
(
  select * from Member where Recommend='gxx2'  //父级名称
  union all
  select a.* from Member a join ds b on a.Recommend=b.LoginName  //子父级关系
)
select * from ds order by CreateTime