select WORKFLOWNAME, wn.NODENAME, wb.SUBCOMPANYID, wb.id, wb.ISVALID
from (select GROUPIDfrom workflow_groupdetailwhere TYPE = 2 and OBJID in (select ROLEID from hrmrolemembers where RESOURCEID in (select ID from hrmresource where LASTNAME = '郭东劭'))) gp
         left join workflow_nodegroup gi on gi.id = gp.GROUPID
         left join workflow_flownode wf on wf.NODEID = gi.NODEID
         left join workflow_nodebase wn on wn.id = wf.NODEID
         left join workflow_base wb on wb.id = wf.WORKFLOWIDwhere SUBCOMPANYID = 389