By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE link_table
(`id` int, `user_id_one` int, `user_id_two` int)
;
INSERT INTO link_table
(`id`, `user_id_one`, `user_id_two`)
VALUES
(1, 1, 2),
(2, 3, 4)
;
CREATE TABLE users
(`id` int, `name` varchar(5))
;
INSERT INTO users
(`id`, `name`)
VALUES
(1, 'jef'),
(2, 'kevin'),
(3, 'mike'),
(4, 'sam')
;
select l.id,
user_id_one,
u1.name as user_id_one_name,
user_id_two,
u2.name as user_id_two_name
from link_table l
inner join users u1 on l.user_id_one = u1.id
inner join users u2 on l.user_id_two = u2.id;
| id | user_id_one | user_id_one_name | user_id_two | user_id_two_name |
|---|---|---|---|---|
| 1 | 1 | jef | 2 | kevin |
| 2 | 3 | mike | 4 | sam |