我不确定 Herachial 数据是否是您需要/想要的，但这是您需要的

i'm not sure if herachial data is what you need/want, but here's what you need

所有上、中、普通会员，DEMO，SQL:

all tops, middle, an regular members, DEMO, SQL :

select 
IFNULL((SELECT name FROM users where uid=smng.leader_id),(SELECT name FROM users where uid=mng.leader_id)) 
         as top, 
(SELECT name FROM users where uid = mng.leader_id) 
         as middle,
usr.name as regular
from 
 users usr inner join managers mng on usr.uid=mng.member_id 
    inner join managers smng on mng.leader_id = smng.member_id

为指定的高层经理添加:

for specified top manager add :

where smng.leader_id =1

对于指定的中层经理更改为:

for a specified middle manager change to :

where mng.leader_id =2