Have a table in which I need to get two user's usernames from it. I.e.
challenge(id, challengerid, receiverid)
challengerid and receiverid are ids from the member table.
how do I get both the challengerid's username aswell as the receiverid's username with the same query?
Any help would be awesome!