select a.fname as 用户名,case when a.fforbidden=0 then '否' else '是' end as 是否禁用,c.fname as 用户组
from t_user a
left join t_group b on a.userid=b.userid
left join t_user c on b.fgroupid=c.userid
where c.fname is not null
from t_user a
left join t_group b on a.userid=b.userid
left join t_user c on b.fgroupid=c.userid
where c.fname is not null