<?php
$link = mysqli_connect("localhost", "root", "", "college");
$query = "SELECT branch, year,semester, COUNT(*) count FROM students GROUP BY branch,year,semester;";
$result = mysqli_query($link,$query);
$rows= mysqli_fetch_all($result,MYSQLI_ASSOC);
echo json_encode($rows);

?>

这是我的输出：
[{“branch”：“cse”，“year”：“1”，“term”：“1”，“count”：“4”}，{“branch”：“cse”，“year”：“2”，“term”：“1”}，{“branch”：“cse”，“year”：“2”，“term”：“2”，“count”：“2”}，{“branch”：“cse”，“year”：“2”，“term”：“4”，“count”：“1”}，{“branch”：“cse”，“year”：“3”，“term”：“count”：“2”}，{“branch”：“cse”，“年”：“4”，“学期”：“3”，“计数”：“1”}，{“分行”：“cse”，“年”：“4”，“学期”：“4”，“计数”：“2”}，{“分行”：“ece”，“年”：“1”，“学期”：“4”，“计数”：“2”}，{“分行”：“ece”，“年”：“2”，“学期”：“2”，“计数”：“2”}，{“分行”：“ece”，“年”：“2”，“学期”：“3”，“计数”：“1”}，{“分行”：“ece”，“年”：“3”，“学期”：“1”，“计数”：“1”}，{“分行”：“ece”，“年”：“3”，“学期”：“3”，“计数”：“2”}，{“分行”：“ece”，“年”：“4”，“学期”：“2”，“计数”：“2”}，{“分行”：“ece”，“年”：“4”，“学期”：“4”，“计数”：“2”}，{“分行”：“eee”，“年”：“1”，“学期”：“1”，“计数”：“1”}，{“分行”：“eee”，“年”：“1”，“学期”：“4”，“计数”：“1”}，{“分行”：“eee”，“年”：“2”，“学期”：“1”，“计数”：“1”}，{“分行”：“eee”，“年”：“2”，“学期”：“2”，“count”：“3”}，{“branch”：“eee”，“year”：“2”，“term”：“3”，“count”：“2”}，{“branch”：“eee”，“year”：“2”，“term”：“4”，“count”：“1”}，{“branch”：“eee”，“year”：“3”，“term”：“1”，“count”：“1”}，{“branch”：“eee”，“year”：“3”，“term”：“3”，“count”：“4”}，{“branch”：“eee”，“year”：“3”，“term”：“4”，“count”：“3”}，{“分行”：“eee”，“年”：“4”，“学期”：“2”，“计数”：“3”}，{“分行”：“eee”，“年”：“4”，“学期”：“3”，“计数”：“2”}，{“分行”：“eee”，“年”：“4”，“学期”：“4”，“计数”：“1”}]
但我想要这样的输出：

{"cse":

[{"year":"1","semester":"1","count":"4"},
{"year":"2","semester":"1","count":"1"},
{"year":"2","semester":"2","count":"2"},
{"year":"2","semester":"4","count":"1"},
{"year":"3","semester":"2","count":"1"},
{"year":"3","semester":"3","count":"2"},
{"year":"4","semester":"3","count":"1"},
{"year":"4","semester":"4","count":"2"}],

"ece":

[{"year":"1","semester":"4","count":"2"},
{"year":"2","semester":"2","count":"2"},
{"year":"2","semester":"3","count":"1"},
{"year":"3","semester":"1","count":"1"},
{"year":"3","semester":"3","count":"2"},
{"year":"4","semester":"2","count":"2"},
{"year":"4","semester":"4","count":"2"}],

"eee":

[{"year":"1","semester":"1","count":"1"},
{"year":"1","semester":"4","count":"1"},
{"year":"2","semester":"1","count":"1"},
{"year":"2","semester":"2","count":"3"},
{"year":"2","semester":"3","count":"2"},
{"year":"2","semester":"4","count":"1"},
{"year":"3","semester":"1","count":"1"},
{"year":"3","semester":"3","count":"4"},
{"year":"3","semester":"4","count":"3"},
{"year":"4","semester":"2","count":"3"},
{"year":"4","semester":"3","count":"2"},
{"year":"4","semester":"4","count":"1"}]}

建议任何其他方式来显示上述输出