How to make such sql query from multiple tables?

Question

SQL

It has a table with user data, as well as a second table with photos of these users.
The id from the first table is linked to the user_id field from the second table. How to write one query that will take all the data of all users from the first table and also hook the name (photo_name field) of the photo from the second table that matches the user?

Answer 1

join to help

Answer 2

select u.*,ui.photo_name
from users as u
left join users_info as ui on u.user_id = ui.user_id