Mybatis sql查询条件为in List，怎么查询

   @Select(
        "<script>" +
        "select vc.* from vc "+
        "where vc.car_id in " +
        "<foreach collection=\"carIdList\" index=\"index\" item=\"id\" open=\"(\" separator=\",\" close=\")\">" +
        " #{id} </foreach> " +
        "</script>")

<foreach>之间的内容查询条件in List