JOIN orders o ON u.user_id = o.user_id; ...

A CROSS JOIN produces the Cartesian product of two tables, combining each row from the first table with every row from the second. A LEFT JOIN keeps all records from the left table while matching them ...