SELECT * FROM friends INNER JOIN users ON friends.user1 = users.id OR ON friends.users2=users.id WHERE friends.valid=1