mysql find_in_set

select * from IpResourceInfo a
where find_in_set(a.id,(SELECT group_concat(CAST(resourcesid AS char)) ss
FROM ipmanage_smh.RoleResources
where roleid='7b40bdde-c4f1-4f6a-8773-a07e3e27e2e0' and resourcestype=21
group by roleid))