select (select realname from b where h_id = a.id) as hname, (select realname from b where p_id = a.id) as pname from a--或:select t.realname as hname,e.realname as pname from a left join b t on a.id = t.h_id left join b e on a.id = e.p_id
select (select realname from b where h_id = a.id) as hname, (select realname from b where p_id = a.id) as pname from a 楼上正解
select (select realname from b where h_id = a.id) as hname,
(select realname from b where p_id = a.id) as pname
from a--或:select t.realname as hname,e.realname as pname
from a left join b t on a.id = t.h_id
left join b e on a.id = e.p_id
(select realname from b where p_id = a.id) as pname
from a
楼上正解