SELECT u.*, g.*, o.logged FROM pun_users AS u INNER JOIN pun_groups AS g ON u.group_id=g.g_id LEFT JOIN pun_online AS o ON o.ident='38.107.191.109' WHERE u.id=1