``您可能认识的人''sql查询

select u.id, u.email, u.name, u.etc    -- Get all my friends    from Friendships as f1    -- Get their friends    inner join Friendships as f2        on f1.friend_id = f2.user_id    -- Get their friends User information    inner join Users as u        on f2.friend_id = u.id    where f1.user_id = @userId

将会是我的起点。