select id_team,
  sum(win) as win,
  sum(loss) as loss,
  sum(draw) as draw,
  sum(goals_s) as goals_s,
  sum(goals_m) as goals_m
from (
select games.id_team_one as id_team,
  IF(games.goals_one>games.goals_two,1,0) as win,
  IF(games.goals_one<games.goals_two,1,0) as loss,
  IF(games.goals_one=games.goals_two,1,0) as draw,
  games.goals_one as goals_s,
  games.goals_two as goals_m
from games
where games.`datetime` < NOW()
union all
select games.id_team_two,
  IF(games.goals_one<games.goals_two,1,0) as win,
  IF(games.goals_one>games.goals_two,1,0) as loss,
  IF(games.goals_one=games.goals_two,1,0) as draw,
  games.goals_two as goals_s,
  games.goals_one as goals_m
from games
where games.`datetime` < NOW()
) t group by id_team