Devi fare una JOIN self
http://database.html.it/articoli/leg...le-in-mysql/4/

SELECT a.ChampionshipID FROM tabella AS a, tabella AS b WHERE a.UserID = 'Iddelprimo' AND b.UserID = 'Iddelsecondo' AND a.ChampionshipID = b.ChampionshipID