mysql> select ug_group, ug_user, user_name, user_real_name from user_groups, user where user_id = ug_user;
+------------+---------+--------------------+----------------------------+
| ug_group   | ug_user | user_name          | user_real_name             |
+------------+---------+--------------------+----------------------------+
| bot        |       2 | Danbri.org         | Dan Brickley               |
| bot        |      64 | LibbyMiller        | Libby Miller               |
| bot        |      94 | Steevc             |                            |
| bot        |     213 | DanBri             | Dan Brickley               |
| bureaucrat |       1 | WikiSysop          |                            |
| bureaucrat |       2 | Danbri.org         | Dan Brickley               |
| bureaucrat |       6 | Kidehen            | Kingsley Uyi Idehen        |
| bureaucrat |       7 | Mortenf            | Morten Høybye Frederiksen |
| bureaucrat |      10 | Melvster.com       |                            |
| bureaucrat |      16 | Tommorris          | Tom Morris                 |
| bureaucrat |      20 | Masaka             |                            |
| bureaucrat |      41 | Duck1123           | Daniel E. Renfer           |
| bureaucrat |      42 | Alkarex            | Alexandre Alapetite        |
| bureaucrat |      59 | Sergey Chernyshev  | Sergey Chernyshev          |
| bureaucrat |      64 | LibbyMiller        | Libby Miller               |
| bureaucrat |      94 | Steevc             |                            |
| bureaucrat |     213 | DanBri             | Dan Brickley               |
| bureaucrat |     216 | Ah1                |                            |
| bureaucrat |     218 | Ah2                |                            |
| bureaucrat |     223 | Akbarhossain.com   |                            |
| bureaucrat |     225 | Melvincarvalho     |                            |
| bureaucrat |     262 | Michael Hausenblas | Michael Hausenblas         |
| coding     |       2 | Danbri.org         | Dan Brickley               |
| sysop      |       1 | WikiSysop          |                            |
| sysop      |       2 | Danbri.org         | Dan Brickley               |
| sysop      |      64 | LibbyMiller        | Libby Miller               |
| sysop      |     213 | DanBri             | Dan Brickley               |
+------------+---------+--------------------+----------------------------+
27 rows in set (0.00 sec)