SELECT my_followers_following.user_id
FROM user_followers AS my_followers
INNER
JOIN user_followers AS my_followers_following
ON my_followers_following.follower_id = my_followers.follower_id
AND my_followers_following.user_id <> my_followers.user_id
WHERE my_followers.user_id = 1
GROUP
BY my_followers_following.user_id
ORDER
BY COUNT(*)
i tested it for you, on the data you posted, using “i am user 1” instead of “i am user A”, and it returns 2 and 3 (1 occurrence each)