表在哪?
字符串拆分
https://blog.csdn.net/pjymyself/article/details/81668157
SELECT status,IF(`Status`="在职","在职1","") AS 拆分1,IF(`Status`="离职","离职2","") AS 拆分2 FROM `wy_hr_employee`

分别查询两种状态的表,然后关联结果
WITH a AS (SELECT id,status AS 拆分1 FROM `wy_hr_employee` a WHERE status = "在职" ),
b AS (SELECT id,status AS 拆分2 FROM `wy_hr_employee` WHERE status = "离职")
SELECT * FROM a,b WHERE a.id = b.id