Why this query to get friends is returning FALSE? : I have a table named friends which contains 3 fields 
user1id, user2id and status.
Status is a foreign key to an another table FriendshipStatuses and both of the other fields are foreign keys to user's table.
So I tried some different queries which resulted in false and getting friendships that were still in request.The query I provided is returning FALSE.
$userId contains the current logged in user's id

 `SELECT users.username, users.fullName, users.user_id 
 FROM users WHERE users.user_id IN(SELECT user1id, user2id
 WHERE user1id=$userId OR user2id = $userId)`
