How to make a double query to the database with a selection of all projects for each user?

Question

Layout

Please tell me how to make a selection from two tables at the same time so that I would have for each usera from the users table all his projects from the projects table (projects are linked by id users)

Answer 1

Recalling my first experiences with svg, the preserveAspectRatio="none" attribute seemed very useful to me in such tasks, and I could not stumble upon it for a long time.

Answer 2

JOIN , I think in your case, LEFT JOIN.