oracle 拼接sql不管用,ORACLESQL拼接问题

SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang'

这个我查询出来是701,702,703这样的数据，

我需要放到WHERE条件中IN出来

SELECT USERGROUPID FROM V_USER_CREGION WHERE USERGROUPID IN ('')

=========不知道怎么拼接单引号和双引号调整不好========

SELECT USERGROUPID FROM V_USER_CREGION WHERE 1=1 ${if(len(a)=0,"","USERGROUPID IN ('SUBSTITUTE(SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang',",","','")")}

这个SQL求解》？？？

===========================================

顺便问一句if条件

${if(len(a)=0,"","")

我这个参数a我可以直接写SQL吗？

'SELECT wm_concat(USERRELATIONID) FROM USER_UNIT WHERE ORGMENBERID='zhangshang'