SELECT
	g.gameid 
	g.status 
	g.datestarted 
	g.datecompleted 
	t.userid
	t.username 
	t.playerstatus 
	FROM games g
	LEFT JOIN transact t ON t.gameid = g.gameid
	WHERE g.gameid = $game_id