SELECT mojangId
FROM players
  INNER JOIN friends ON players.id = friends.player1
WHERE friends.player2 = 3

UNION

SELECT mojangId
FROM players
  INNER JOIN friends ON players.id = friends.player2
WHERE friends.player1 = 3