Shouldn't this have been marked as off-topic?

Anyway, in a subquery-free SQL db, you can do this on the fly by joining to the same table repeatedly as needed.

SELECT battle.match_id
     , winner.screen_name AS winner_name -- <- really player.X
     , loser.screen_name  AS loser_name  -- <- really player.X
FROM   battle
     , player AS winner   -- <---------------- see? same table
     , player AS loser    -- <---------------- used twice
WHERE  battle.winner = winner.player_id
  AND  battle.loser  = loser.player_id;
[download]

    --k.