That happens when a user has 5 orders. A LEFT JOIN returns a row for every match in the right table. You either need to add `GROUP BY users.id` or fetch them separately in PHP.