User list of MySQL

user.sql

SHOW PROCESSLIST;
+----+-------------+----------------------+---------------------+---------+-------+-------+------------------+
| Id | User        | Host                 | db                  | Command | Time  | State | Info             |
+----+-------------+----------------------+---------------------+---------+-------+-------+------------------+
| 12 | root        | 192.168.1.1:52451    | NULL                | Query   |     0 | NULL  | SHOW PROCESSLIST |
+----+-------------+----------------------+---------------------+---------+-------+-------+------------------+
8 rows in set (0.01 sec)

SELECT LEFT(host, IF(LOCATE(':', host), LOCATE(':', host), LENGTH(host) + 1) - 1) AS
host_short,GROUP_CONCAT(DISTINCT USER) AS users,COUNT(*)
FROM   information_schema.processlist
GROUP  BY host_short
ORDER  BY COUNT(*),host_short;

--Onde a saída ficará assim:
+----------------+-------------+----------+
| host_short     | users       | COUNT(*) |
+----------------+-------------+----------+
| 192.168.1.1    | user1       |        1 |
| 192.168.1.1    | user2       |        1 |
| 192.168.1.1    | user3       |        6 |
+----------------+-------------+----------+
3 rows in set (0.01 sec)