Mybatis foreach

//import org.apache.ibatis.annotations.Param;

List<Entity> `selectEnshrineByGroupIdAndUserId(@Param("userId") String userId, @Param("groupId") List<String> groupId);`

//mapper

 <select id="selectEnshrineByGroupIdAndUserId"
   resultType="Entity">
       select
       <include refid="list1" />
       ,
       <include refid="list2" />
       from pt
       where id = #{id,jdbcType=VARCHAR}
       and group_id in
       <foreach collection="groupId" item="param" index="index" open="(" close=")" separator=",">
         #{param,jdbcType=VARCHAR}
       </foreach>   
  </select>

	//insert	foreach
  <insert id="insertBatch" parameterType="Entity">
    insert into test_menu(t1_id, t2_id) values
    <foreach collection="ids" item="param" index="index" separator="," close=";">
        (#{param,jdbcType=INTEGER},#{t2_id,jdbcType=INTEGER})
    </foreach>
  </insert>