select a.id,a.uid,b1.name uname,a.createid, b2.name createname from a left outer jon b b1 on a.uid = b1.id left outer jon b b2 on a.createid = b2.id
你表设计的有问题。重新设计
