php - 从表 SQL 统计数据

Question

我的查询:

           "SELECT id
            FROM user_follow
            WHERE user_id IN(3,6) AND follow_id NOT IN(3,6)
            GROUP BY follow_id";

它显示:

[users] => Array
    (
        [0] => Array
            (
                [id] => 20
            )

        [1] => Array
            (
                [id] => 9
            )

        [2] => Array
            (
                [id] => 19
            )

    )

我需要计算数据(在此示例中查询必须返回 3 作为结果)

---

我尝试了 COUNT(id) 但结果对我来说并不好。

结果:

        [0] => Array
            (
                [count(id)] => 1
            )

我试过 SELECT count(1)

结果:

        [0] => Array
            (
                [count(1)] => 1
            )

        [1] => Array
            (
                [count(1)] => 2
            )

        [2] => Array
            (
                [count(1)] => 1
            )

仍然不是一个数字 (3)。我想要这样的东西 [users] => 3

Answer 1

如果您只需要数字而不需要数据本身，您可以试试这个:

SELECT count(1)
FROM user_follow
WHERE user_id IN(3,6) AND follow_id NOT IN(3,6)
GROUP BY follow_id