Implementation steps of Mysql merge results and horizontal splicing fields

SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE (Joining time!= ''
  OR Joining Date IS NOT NULL) and DATE_FORMAT(Joining Date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY Department Name

SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE (resignation date != ''
  OR Leaving Date IS NOT NULL) and DATE_FORMAT(Joining Date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY Department Name

SELECT a.dept,a.rcNumber,0 as lcNumber FROM (SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE (Joining time!= ''
  OR Joining Date IS NOT NULL) and DATE_FORMAT(Joining Date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY department name) a

SELECT a.dept,a.lcNumber,0 as rcNumber FROM (SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE (resignation date != ''
  OR Leaving Date IS NOT NULL) and DATE_FORMAT(Joining Date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY department name) a

SELECT dept ,sum(cm_1) as rcNumber,sum(cm_0) as lcNumber FROM( SELECT c.id,c.dept,SUM(c.lcNumber) as cm_0,c.rcNumber as cm_1 FROM 
(SELECT a.dept,a.rcNumber,0 as lcNumber FROM (SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE (Joining time!= ''
  OR Joining Date IS NOT NULL) and DATE_FORMAT(Joining Date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY department name) a) c GROUP BY c.dept
UNION ALL 
SELECT d.id,d.dept,d.lcNumber as cm_0,SUM(d.rcNumber) as cm_1 FROM 
(SELECT a.dept,a.lcNumber,0 as rcNumber FROM (SELECT dept ,COUNT(1) rcNumber FROM employee table WHERE ( resignation time != ''
  OR quit_date IS NOT NULL) and DATE_FORMAT(join_date, '%Y-%m') = '2019-09'
GROUP BY department ID
ORDER BY department name) a) d GROUP BY d.dept) t GROUP BY t.dept ORDER BY t.id