<select id="byID" resultType="ClubMember">
select a.id as rid,a.register_date,b.name as cname,c.name as mname from Club_Member a,Club b,Member c where a.member_id = c.id and a.club_id = b.id and a.member_id = #{id}
</select>

class ClubMember {
private int rid;
private Date register_date;
private String cname;
private String mname;
.....
}

如上一次即可查出