Nasıl katılabilirsiniz users ile users_friends.user_id zaman user_id = '" . $user_id . "'

Ve katılmak users users_friends.friend_id zaman friend_id = '" . $user_id . "' ile

Eğer user_id = '" . $user_id . "'

INNER JOIN users ON users_friends.user_id = users.user_id

Eğer friend_id = '" . $user_id . "'

INNER JOIN users ON users_friends.friend_id = users.user_id

Güncel MySQL Kodu.

SELECT COUNT(user_id) as friends
FROM users_friends
WHERE (user_id = '" . $user_id . "' 
OR friend_id = '" . $user_id . "')
AND friendship_status = '1'