php mysql อยากได้ข้อมูลออกมาแบบในรูปครับ

SELECT 
  IFNULL(c.dayin, c.dayout) as dayin, 
  IFNULL(c.qtyin, 0) as qtyin, 
  IFNULL(c.dayout, c.dayin) dayout, 
  SUM(
    IF(
      ! ISNULL(c.qtyin) 
      AND ! ISNULL(c.qtyout), 
      0, 
      IFNULL(c.qtyout, 0)
    )
  ) as qtyout, 
  CONCAT(
    IFNULL(c.dayin, c.dayout), 
    IFNULL(c.dayout, c.dayin)
  ) as day 
FROM 
  (
    SELECT 
      a.dayin, 
      a.qtyin, 
      NULL as dayout, 
      NULL as qtyout 
    FROM 
      tbl_a a 
    GROUP BY 
      a.id, 
      dayin 
    HAVING 
      a.id = 1 
    UNION 
    SELECT 
      NULL as dayin, 
      NULL as qtyin, 
      b.dayout, 
      b.qtyout 
    FROM 
      tbl_b b 
    GROUP BY 
      b.id_a, 
      dayout 
    HAVING 
      b.id_a = 1 
    UNION 
    SELECT 
      a.dayin, 
      a.qtyin, 
      b.dayout, 
      b.qtyout 
    FROM 
      tbl_a a, 
      tbl_b b 
    WHERE 
      a.dayin = b.dayout 
      AND a.id = b.id_a 
      AND a.id = 1
  ) c 
GROUP BY 
  day 
ORDER BY 
  dayin