SQL Query without nested queries

select u.id, u.username, u.email, g.groupid, g.groupname
from user u
join user2group ug on u.userid=ug.userid
join group g on g.groupid=ug.groupid
order by u.userid

SELECT
  u.id,
  u.username,
  u.email,
  g.groupid,
  g.groupname
FROM
  user u
  LEFT JOIN user2group ug ON u.userid = ug.userid
  LEFT JOIN group g ON g.groupid = ug.groupid
ORDER BY
  u.userid