php - 我如何获取我关注的人但他们不关注？

Question

所以我有一个名为follow_sys三列的表id，follower其中following包含关注者的用户名和关注者，所以我想获取我关注的所有关注者，但他们不关注我，我该怎么做？

我尝试了自我加入，但它没有用，我很困惑

    $sqlFollowing      = "SELECT * from follows_syds t1
                               join follows_syds t2 on
                               t1.follower != t2.following
                               where
                               t1.follower = ?
                               group by t1.id";
$Following         = $conn -> prepare($sqlFollowing);
$Following        -> bind_param('s',$getUser);
$Following        -> execute();
$FollowingGET      = $Following -> get_result();
$FollowingRows     = $FollowingGET -> num_rows;

while($b = $FollowingGET -> fetch_assoc()){

print_r($b);
echo "</br>";
}

标签： phpmysqlsql-serverajaxmysqli