select
 m.pid,
 m.name,
 ma.alias
from
 member m
left outer join
(
	select
	 a.aid,
	 a.pid,
	 a.alias
	from
	 alias a
	inner join
	(
	 select
	  min(aid) as aid,
	  pid
	 from
	  alias
	  group by pid
	) t on a.aid = t.aid
)
ma on m.pid = ma.pid;