public class User{ /** * 人员编码 */ private String personCode; /** * 人员姓名 */ private String personName; /** * codes */ private List<String> codes; } <resultMap type="com.user.User" id="UserMap"> <result property="personName" column="person_name"/> <result property="personCode" column="person_code"/> <collection property="codes" ofType="string"> <result column="code"/> </collection> </resultMap> <select id="groupBYPersonCode" resultMap="UserMapper"> SELECT a.person_code, a.person_name, b.`code` FROM `user` a LEFT JOIN role b ON a.id = b.user_id GROUP BY a.person_code, b.`code` ORDER BY a.person_code </select>