<#--查询userList中没离职的id--> select GROUP_CONCAT(userid) as useridStr from t_bus_user_personnel where leave_date is null <#if ( useridList )?? && useridList ?size gt 0> and userid in( <#list useridList as item> '${item}' <#if item_has_next>, )