How to combine data from 2 mysql queries?

Question

MySQL

Good afternoon! I'm just learning MYSQL. Help me please.
The problem is this:
There are 2 tables (reviews, users)
If you query each table separately, the result looks something like this:
reviews: [
[0]: [
id: 1,
text: "Review text",
user_id: 5
],
[ 1]: [
id: 1,
text: "Review text 2",
user_id: 3
]
]
users: [
[0]: [
id: 5,
name: "Ivan",
surname: "Ivanov"
],
[1]: [
id: 3,
name: "Nicholas",
surname: "Nikolaev"
]
]
Is it possible to end up with something like this:
reviews: [
[0]: [
id: 1,
text: "Review text",
user_name: "Ivan"
user_surname: "Ivanov "
],
[1]: [
id: 1,
text: "Review text 2",
user_name: "Nikolai"
user_surname: "Nikolaev"
]
]
That is, to combine the data but at the same time so that the User's data is exactly the one whose ID is specified in the user_id field.

Answer 1

JOIN, LEFT JOIN, RIGHT JOIN are the most useful thing to recommend in this situation.