mybatis查询结果一对多

    
        SELECT
	        u.id uid,
	        u.user_name,
	        u.account,
	        u.pwd,
	        u.mail,
	        u.telephone,
	        u.create_time,
	        u.last_login_time,
	        u.login_ip,
	        u.login_area,
	        u.user_status,
	        r.id rid,
	        r.role_name,
	        r.role_desc,
	        p.permission_name,
	        p.permission_desc
        FROM
	        t_user u
        LEFT JOIN
            t_user_role ur ON u.id = ur.user_id
        LEFT JOIN
            t_role r ON ur.role_id = r.id
        LEFT JOIN
            t_role_permission rp ON rp.role_id = r.id
        LEFT JOIN
            t_permission p ON p.id = rp.permission_id
        
    

　　查询结果有多个的时候可以用collection标签接收集合