apmēram kaut kas uz to pusi:
SELECT u.uid,vards,cits_useralauks, f.*, ff.*
FROM `users` u, `friendships` f, `friendships` ff
WHERE f.myid='". uid ."'
AND f.friend_1_id = ff.friend_2_id
AND ff.friend_1_id = u.uid
AND ff.friend_1_id != f.friend_1_id
AND f.friend_1_id != ff.friend_1_id
AND ff.friend_1_id != ". uid ."
AND f.myid != ff.friendid
AND ff.friend_1_id != f.friend_2_id
AND f.friend_1_id != ff.friend_1_id
GROUP BY ff.friend_1_id
ORDER BY ff.friend_1_id DESC, ff.friend_1_id DESC