select a.id,a.tt,a.kk,b.money,c.name from a left join b on a.id=b.uid left join c on a.id=c.tidgroup by a.kk试试吧