MySQL 计数，其中行 = 0 - mysql count where row = 0

我试图显示计数，但仅限于列deleted等于 0 的地方

这是我尝试过的

$result=mysql_query("SELECT * FROM users where deleted=0")or die('Error ' );
$counter = mysql_query("SELECT COUNT(*) as personID FROM users");
$row = mysql_fetch_array($result);
    $personID = $row['personID'];
    $personFname = $row['personFname'];
    $personSname = $row['personSname'] ;
    $llmail = $row['llmail'];
    $mainadmin = $row['mainadmin'];
     $delete = $row['delete'];
$num = mysql_fetch_array($counter);
$count1 = $num["personID"];

这

显示了 4 个计数，但是在 4 个中，2 个被删除，所以如果这有意义，它应该只显示 2

？

SELECT COUNT(*) as personID FROM users WHERE deleted=0