meidu2021/daju/target/classes/cn/com/lzt/personnelbasearchivesmanage/sql/PersonnelBaseArchivesManageDao_getUserIdByRole.sql

SELECT DISTINCT ru.userid as id from t_s_role r
LEFT JOIN t_s_role_user ru
ON r.ID = ru.roleid
where r.rolecode in (
	<#list params as item>        
	   '${item}'
	 <#if item_has_next>,</#if>
	 </#list>
) and ru.userid !=''