friendship_id   request_from    request_to  friendship_status
1               111248          111249      1
2               111209          111249      1
3               111209          111248      0
11              111209          111259      1
5               111252          111209      1
12              111261          111209      1

SELECT * FROM users_status WHERE userid = "$userid"
    OR userid in (SELECT request_to   FROM friendships where request_from = "$userid" AND friendship_status = 1)
    OR userid in (SELECT request_from FROM friendships where request_to   = "$userid" AND friendship_status = 1)

PENDING_FRIENDSHIPS(request_from, request_to)
FRIENDSHIPS(request_from, request_to)

select * from friendships
where $currentUser = request_from OR $currentUser = request_to

select request_from from friendships
where request_to = $currentUser
UNION
select request_to from friendships
where request_from = $currentUser