我有 4 張桌子。表組| ID | NAME |  1    Premium  2    Silver表用戶| ID | group_id | NAME |  1       1      Serhan  2       2      Farhat表 user_statistics| ID | user_id | TYPE |  1       1      1  2       2      0桌票| ID | user_id | VOTE |  1       1      1  2       2      0  3       1      0我創(chuàng)建了一個(gè) sql 查詢來檢索同一組中的用戶詳細(xì)信息。成功了！然后我想檢索任何已投票給用戶的投票。我要數(shù)票。所以基本上我已經(jīng)做了這個(gè) sql 查詢。global $conn;$res_groups = array();$stmt = $conn->prepare("    SELECT * FROM groups");$stmt->execute();$stmt->setFetchMode(PDO::FETCH_ASSOC);while ($group = $stmt->fetch()){    $groups = array();    $groups['id'] = $group['id'];    $groups['name'] = $group['name'];    $user_arr = array();    $stmts = $conn->prepare('        SELECT l.*,        (SELECT MAX(ls.date) from user_statistics ls WHERE ls.user_id = l.id GROUP BY ls.user_id) as ls_date,        (SELECT SUM(IF(ls.type="0", ls.type, 0)) FROM user_statistics ls WHERE ls.user_id = l.id GROUP BY ls.user_id) as ls_us,        (SELECT SUM(IF(ls.type="1", ls.type, 0)) FROM user_statistics ls WHERE ls.user_id = l.id  GROUP BY ls.user_id) as ls_uk,        (SELECT COUNT(*) FROM user_statistics WHERE type="1" AND ls.user_id = l.id GROUP BY ls.user_id) as totals,        (SELECT COUNT(*) FROM votes v WHERE v.vote=0 AND confirm=0 AND v.user_id = l.id) as badvote,        (SELECT COUNT(*) FROM votes v WHERE v.vote=1 AND confirm=0 AND v.user_id = l.id) as goodvote        FROM user l        LEFT JOIN        user_statistics ls on l.id = ls.user_id        LEFT JOIN votes v on v.user_id = l.id        WHERE l.group_id = '.$groups['id'].' AND status = 1        GROUP BY l.id,ls.user_id    ');除非一件事，否則所有代碼似乎都有效。VOTE 始終返回以計(jì)算我的數(shù)據(jù)庫 VOTES 中的所有列并將數(shù)據(jù)應(yīng)用于我的所有用戶。我想要的是根據(jù)投票類型 GOOD 或 BAD 獲得每個(gè)用戶獲得多少票。任何幫助都會(huì)很好。