How to form SQL correctly?

Question

SQL

Good afternoon, there are 2 tables
sites
-----
id
http
reward
time
and
users
------
id
user_id
time
site_id
You need to select SELECT * FROM sitesand

SELECT time_in_sec FROM sites, users WHERE sites.id = users.site_id

How to combine them so that all the information from the first request is displayed, and only that which is needed from the second, how to do this with one request?
I assume that $result[something] in one of them contains information on the second request, and in which there is none, they will be null

Answer 1

SELECT * FROM sites LEFT JOIN users ON sites.id = site_id