You should have an additional table for game data. I accidentally said column, but meant table. That way you can reference the latest matches and figure out the winners. It should have the following columns.

  • game_id
  • timestamp
  • player_1_id (match with user's table)
  • player_2_id (match with user's table)
  • winner_id (match with user's table)