mysql两条查询语句的拼接

今天前同事业务上遇到点问题，请求帮助，我看了下，具体需求是需要展示今天的数据和总的数据。
具体实现看sql

SELECT t.sysno,t.name,SUM(cm_1) AS count1,SUM(cm_0) AS todaycount FROM (
	SELECT c.sysno,c.name,SUM(c.todaycount) AS cm_0,c.count1 AS cm_1 FROM
	(SELECT a.sysno,a.name,a.count1,0 AS todaycount FROM 
	(SELECT s.sysno,s.name, COUNT(r.receive_id) AS `count1`
        FROM sys_user s LEFT JOIN customer_info r
        ON s.sysno=r.receive_id
        GROUP BY s.name, r.receive_id) a) c GROUP BY c.sysno
        
        UNION ALL
        
        SELECT d.sysno,d.name,d.todaycount AS cm_0,SUM(d.count1) AS cm_1 FROM
	(SELECT b.sysno,b.name,b.todaycount,0 AS count1 FROM 
	(SELECT s.sysno,s.name,COUNT(s.sysno) AS todaycount
        FROM sys_user s LEFT JOIN customer_info r
        ON s.sysno=r.receive_id
        WHERE  TO_DAYS(r.visit_time) = TO_DAYS(NOW())
        GROUP BY s.name,s.sysno) b) d GROUP BY d.sysno) t GROUP BY t.sysno 

优化后的sql

SELECT t1.sysno ,t1.name, IFNULL(t3.recriveCount,0),IFNULL(t6.recriveSumCount,0) FROM  sys_user t1 LEFT JOIN 
 ( 
 SELECT t2.receive_id , COUNT( t2.receive_id ) AS recriveCount FROM customer_info t2 WHERE TO_DAYS(t2.visit_time) = TO_DAYS(NOW())
  GROUP BY t2.receive_id
 )  t3 ON t3. receive_id = t1.sysno 
 
 LEFT JOIN 
 ( 
 SELECT t5.receive_id , COUNT( t5.receive_id ) AS recriveSumCount FROM customer_info t5 
  GROUP BY t5.receive_id
 )  t6 ON t6.receive_id = t1.sysno