我有這個(gè)問題，首先要獲取學(xué)生總數(shù)，然后是 amount_paid 列中學(xué)生支付的總金額，我正在查詢所有學(xué)生 id(system_id)，然后是每筆付款，然后是發(fā)票和發(fā)票的成本費(fèi)用目標(biāo)是與學(xué)生匹配的 id。最后，我嘗試減去循環(huán)中發(fā)送給選定學(xué)生的所有發(fā)票的總金額，然后從同一循環(huán)中發(fā)送給目標(biāo)學(xué)生的費(fèi)用中減去它。現(xiàn)在，我的許多問題是，對于第一批學(xué)生來說，它正在計(jì)算余額罰款，但其余的余額正在迅速增加。請問我的代碼問題出在哪里：<?php$students = mysqli_query($conn, "SELECT * FROM students GROUP BY system_id");while($row = mysqli_fetch_assoc($students)){    $user_uid = $row['system_id'];    $exam = $row['exam_number'];   //getting payments balances//gettingshopping cart details      $Balance_query = mysqli_query($conn,  "SELECT SUM(amount_paid) AS 'sumitem_cost' FROM payments WHERE payment_by='$user_uid' ");          $balance_data = mysqli_fetch_array($Balance_query);      $balance_price = $balance_data['sumitem_cost'];            $py = mysqli_query($conn, "SELECT * FROM payments WHERE payment_by='$user_uid' AND status!='rejected' GROUP BY invoice_id");      while($rowpy = mysqli_fetch_assoc($py)){                    $paidAmout = $rowpy['amount'];          $invoiceId = mysqli_real_escape_string($conn, $rowpy['invoice_id']);          $PaymentStatus = mysqli_real_escape_string($conn, $rowpy['status']);          //Getting invoice          $Invoice = mysqli_query($conn, "SELECT * FROM invoices WHERE id='$invoiceId'");                    while($rowInv = mysqli_fetch_assoc($Invoice)){          $NewFeeId = $rowInv['id'];                    $sql = mysqli_query($conn,"SELECT SUM(fee) as total FROM invoices WHERE id='$invoiceId'");         $row = mysqli_fetch_array($sql);          $sum = $row['total'];          $total_price += $row[‘fee’];      }}     echo'<br>'.$exam.':' . $BalanceToPay =  $total_price - $balance_price;      }?>