SELECT users1.username AS username1, users2.username AS username2
FROM test
JOIN users AS users1 ON test.userid1=users1.id
JOIN users AS users2 ON test.userid2=users2.id