How to merge tables?

Question

MySQL

There are two tables

User


Relationships


I need to merge the tables in such a way that instead of all id-shniks in the "User Relationships" table their names are displayed, that is, name from the users table.

Answer 1

Make a selection from the relationship table and select three joins of the user table for each join to each field, and in the select specify the name fields of these three joined tables