mybatis-plus中的@Select注解里面写sql语句的in

@Select("<script>" + "select \n" + "email \n" + "from sys_user\n" + "where id in \n" + " <foreach item='item' index='index' collection='ids' open='(' separator=',' close=')'>" + " #{item}" + " </foreach>" + "</script>" ) List<String> listEmailByIdBatch(@Param("ids") List<String> ids);