SELECT
    a.user_id AS user1,
    b.fans_id AS user2
FROM
    follow_df a
JOIN
    follow_df b ON a.user_id = b.fans_id AND a.fans_id = b.user_id
WHERE
    a.dt = b.dt
ORDER BY
    user1, user2;