+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| msgID     | int(11)      | NO   | PRI | NULL    | auto_increment |
| userID    | int(11)      | NO   |     | NULL    |                |
| msgText   | varchar(255) | NO   |     | NULL    |                |
| msgStatus | varchar(255) | NO   |     | NULL    |                |
| userName  | varchar(255) | NO   |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+

+-------+--------+-------------------+-----------+----------+
| msgID | userID | msgText           | msgStatus | userName |
+-------+--------+-------------------+-----------+----------+
|     1 |      1 | hi                | unread    | Francis  |
|     2 |      2 | hello             | unread    | Emma     |
|     3 |      1 | good              | unread    | Francis  |
|     4 |      1 | your not easy     | read      | Francis  |
|     5 |      2 | just no that      | unread    | Emma     |
|     6 |      2 | don't lose it bro | unread    | Emma     |
|     7 |      2 | good keep it up   | unread    | Emma     |
|     8 |      3 | i don't hate it   | unread    | John     |
+-------+--------+-------------------+-----------+----------+

+--------+----------+
| userID | userName |
+--------+----------+
|      1 | Francis  |
|      2 | Emma     |
|      3 | John     |
+--------+----------+

select userID, userName FROM msg GROUP BY userID;