How to replace table id with names from other table?

Question

MySQL

There is a table logs (id, product_id, count, user_id, status)
How to organize a query to replace product_id with names from the products(id, name) table, and user_id with names from the user(id, name) table?

Answer 1

SELECT products.name AS product_name, user.name AS user_name
FROM logs
LEFT JOIN products ON products.id = logs.product_id
LEFT JOIN user ON user.id = logs.user_id