这个时候需要定义别名了,用到@Param(value=""):
@Select({"<script> ",
"SELECT a.item_id,b.name,b.mcid FROM me_category_item a INNER JOIN me_category b on a.mcid = b.mcid ",
"WHERE b.pid IN ",
"<foreach collection = 'mcids' separator = ',' open = '(' close = ')' item = 'id'> ",
"#{id} ",
"</foreach> ",
"</script>"})
List<MeCategoryItem> getItemIdByMcids(@Param("mcids") Set<Integer> mcids);