SELECT a.`字段1`, a.`字段2` , a.`字段r3` FROM `表` b LEFT JOIN `表` a ON (b.`字段1`=a.`字段1`) GROUP BY a.`字段1` ,a.`字段2`,a.`字段3`