I want to show a output table that counts all the users found in a table. 
Basically I want the output to look like:

```
+-----------+-----------+
| user1     | user2     |
+-----------+-----------+
|         5 |         2 |
+-----------+-----------+

```

I'm just using a dummy table to test this. My query looks like this:

```
(
    select 
        name as user1 
    from 
        users 
    where 
        name = 'root'
) UNION (
    select 
        name as user2 
    from
        users 
    where 
        name = 'not_root'
)

```

Which only outputs something like this:

```
+-----------+
| user1     |
+-----------+
|         5 |
|         2 |
+-----------+

```