在mybatis中的foreach中同时迭代两个列表

public interface MyMapper {
    List<MyObject> selectByTwoLists(Map<String, Object> map);
}

<select id="selectByTwoLists" resultType="MyObject">
    SELECT *
    FROM my_table
    WHERE column1 IN
    <foreach collection="list1" item="item" open="(" separator="," close=")">
        #{item}
    </foreach>
    AND column2 IN
    <foreach collection="list2" item="item" open="(" separator="," close=")">
        #{item}
    </foreach>
</select>

List<String> list1 = Arrays.asList("value1", "value2", "value3");
List<String> list2 = Arrays.asList("value4", "value5", "value6");

Map<String, Object> map = new HashMap<>();
map.put("list1", list1);
map.put("list2", list2);

List<MyObject> result = myMapper.selectByTwoLists(map);