Multiple count queries elastic search

I have 2 queries resulting count of user request in diff time period.

How to merge this and show as a table

Query 1

Columns
1 Username
2 today’scount

Query 2

1 Username
2 yesterday’scount

I need result as
Table

1Username
2 today’scount
3yesterdayscount