SELECT-ntapply_unitsnamentFROMn----sys_category-a-INNER-JOIN-special_manage-bnWHEREn----aid=bwork_typen----AND-bstatus=2nGROUP-BY-apply_unitsn修改此SQL以name的结果的每一项作为列进行查询

SELECT MAX(CASE WHEN name = 'column1' THEN apply_units END) AS column1, MAX(CASE WHEN name = 'column2' THEN apply_units END) AS column2, MAX(CASE WHEN name = 'column3' THEN apply_units END) AS column3, MAX(CASE WHEN name = 'column4' THEN apply_units END) AS column4 FROM sys_category a INNER JOIN special_manage b ON a.id=b.work_type WHERE b.status=2 GROUP BY apply_units;