SELECT
	wb.*,
	wf.NODEID,
	wn.NODENAME,
	wng.GROUPNAME,
	wgd.TYPE,
	wgm.VALUE_FIELD,
	mi.DISPLAYNAME AS 节点矩阵,
	LABELNAME AS 表单矩阵

FROM
	( SELECT id, WORKFLOWNAME, SUBCOMPANYID FROM workflow_base  WHERE SUBCOMPANYID = 101 AND ISVALID = 1 ) AS wb
	LEFT JOIN workflow_flownode wf ON wf.WORKFLOWID = wb.id
	LEFT JOIN workflow_nodebase wn ON wf.NODEID = wn.id
	LEFT JOIN workflow_nodegroup wng ON wng.NODEID = wf.NODEID
	LEFT JOIN workflow_groupdetail wgd ON wgd.GROUPID = wng.ID
	LEFT JOIN workflow_groupdetail_matrix wgm ON wgm.GROUPDETAILID = wgd.ID
	LEFT JOIN matrixfieldinfo mi ON mi.ID = wgm.VALUE_FIELD

	LEFT JOIN workflow_datainput_field wdf ON wdf.PAGEFIELDNAME = (
	CONCAT( "field", OBJID ))
	LEFT JOIN hrm_formfield hf ON hf.FIELDNAME = wdf.DBFIELDNAME
	LEFT JOIN htmllabelinfo html ON hf.FIELDLABEL = html.INDEXID

	WHERE wgd.TYPE IN (5,99)

type = 5  表单通过字段联动带出矩阵

type = 99 节点直接设置矩阵

附件：

矩阵-流程节点对应关系表.xls