mysql查询领导的信息_sql语句查询上下级信息

/*查找邀请码为5TU422所有的下级*/

WITH T AS(

SELECT

invitation_code,

inviter_invitation_code,

user_name,

0 L

FROM

axc_users

WHERE

invitation_code = '5TU422'

UNION ALL

SELECT

U.invitation_code,

U.inviter_invitation_code,

U.user_name,

L + 1

FROM

axc_users U

INNER JOIN T ON

U.inviter_invitation_code = T.invitation_code )

SELECT *FROM T

/*查找邀请码为5TU422所有的上级*/

WITH T AS(

SELECT

invitation_code,

inviter_invitation_code,

user_name,

0 L

FROM

axc_users

WHERE

invitation_code = '5TU422'

UNION ALL

SELECT

U.invitation_code,

U.inviter_invitation_code,

U.user_name,

L + 1

FROM

axc_users U

INNER JOIN T ON

U.invitation_code = T.inviter_invitation_code ) SELECT

*

FROM

T