在while遍历一次累加要求和的字段
$cbumen = mysqli_query($daohang, 'SELECT * FROM baa WHERE bumen=1);
while($row = mysqli_fetch_array($cbumen)){
$qudaoma=$row['qudaoma'];
$jr = mysqli_query($conn, 'SELECT * FROM kh WHERE user_id='.$qudaoma.' ');
$jrtj=0;
while($rjrow = mysqli_fetch_array($jr)){
$jrtj=$rjrow["要求和的字段名"];
}
echo $jrtj;
}
或者直接sql求和
$cbumen = mysqli_query($daohang, 'SELECT * FROM baa WHERE bumen=1);
while($row = mysqli_fetch_array($cbumen)){
$qudaoma=$row['qudaoma'];
$jr = mysqli_query($conn, 'SELECT sum(要求和的字段名) as total FROM kh WHERE user_id='.$qudaoma.' ');
$rjrow = mysqli_fetch_array($jr);
$jrtj=$rjrow["total"];
echo $jrtj;
}