复杂sql查询

同一张表查询数据

 select a.group_id from (select  * from group_member where user_id = #{arg0} ) a INNER JOIN
        (select  * from group_member where user_id = #{arg1}) b
        on  a.group_id = b.group_id;