select pid,pname from u_p up  left join project  p on  p.pid = uo.pdi left join user  u on  u.uid = up.uid shere u.uname = 'ming' ;