User table

```
------------------------
id        |   name
------------------------
1         |  Bob Smith
2         |  Jane Doe
3         |  Fred Flintstone
4         |  Barney Rubble
5         |  Marge Simpson
...       |  ...

```

Connections

```
-----------------------------------------------
connection1 |   connection2  | connector
------------------------------------------------
1           |  3             | 7
11          |  5             | 7
35          |  7             | 7
18          |  9             | 7
12          |  13            | 6
...         |  ...           | ...

```

Above are examples of tables I have in a MySQL database. I understand I can use a WHERE clause to return a single user id but I would like to resolve all ids from the same user table. Is there any elegant solution to return just usernames in one MySQL statement?

Basically return a table like this:

```
-----------------------------------------------
connection1 |   connection2  | connector
------------------------------------------------
Tim         |  Steven        | Charlie

```