select pe.ProjectId , GROUP_CONCAT(pe.Email) as Email from Project_Email pe group by pe.ProjectId 结果图下: