webusers 字段说明:
1、u_id 自增ID
2、u_name 用户姓名
3、p_id 推荐人的u_id
select a.users,b.u_name
from (select GROUP_CONCAT(u_name) as users,p_id from webusers
GROUP BY p_id
) a
INNER JOIN webusers b
on a.p_id =b.u_id
webusers 字段说明:
1、u_id 自增ID
2、u_name 用户姓名
3、p_id 推荐人的u_id
select a.users,b.u_name
from (select GROUP_CONCAT(u_name) as users,p_id from webusers
GROUP BY p_id
) a
INNER JOIN webusers b
on a.p_id =b.u_id