Mysql query with COUNT, SUBTOTAL and GRANDTOTAL - how to build?

Question

MySQL

Without using PHP
There is a table of visits, only 4 columns - timestamp, ip, useragent, daynumber
Please tell me how to build a query using MySQL (extensions are allowed) so that in the resulting output, in addition to the data, there are SUBTOTAL rows (number of rows) and GRANDTOTAL. Count subtotals - by the number of rows with a single identifier daynumber
I.e. something like this output is needed (see the picture)
Please save me - in PHP it turns out very ugly when you can do everything using SQL ))

Answer 1

Of course, you can extract all this data from mysql using sql, but not in this form, you still have to process them to get the look you have. And the request to the mysql server itself will not be optimal and will consume resources when executed.
The ideal solution to the problem in this case is to get all the data using sql with one simple query, and only then bring it into the desired form in php.
Well, if you really want to, then here's an example of how to get all the necessary data:

(SELECT
  timestamp, 
  ip, 
  useragent, 
  daynumber, 
  count(*) as total
FROM 
  table
GROUP BY 
  daynumber
)
UNION
(SELECT
  '' as timestamp,
  '' as ip, 
  '' as useragent, 
  '' as daynumber, 
  count(*) as total
FROM 
  table
)

The result will be a table, the last column of which will show the subtotal of the current daynumber, and the last row will show GRANDTOTAL