如何在codeigniter中执行关于COUNT查询的num_rows() ?

This works:

如此:

        $sql = "SELECT id
                FROM `users`
                WHERE `account_status` = '" . $i . "'"; 
        $query = $this->db->query($sql);
        var_dump($query->num_rows());
        $sql = "SELECT id