将MyBatis代码转换为SQL：用户、角色和部门权限查询

SELECT * FROM table WHERE (','||toc.writeuserids||',' like '%,U'||#userid#||'%') OR (#roles[]# IN (SELECT * FROM roles) AND ','||toc.writeroleids||',' like '%,'||#roles[]#||',%') OR (#cat_deptids[]# IN (SELECT * FROM cat_deptids) AND ','||toc.writeuserids||',' like '%,D'||#cat_deptids[]#||',%')