Usage of mysql when filtering group by combinations of Multiple Fields

To achieve this effect

If a group by condition is used, the results will be much less. How can I combine multiple conditions for filtering?

Copy codeThe Code is as follows: group by fielda, fieldb, fieldc...

During the loop, you can determine whether the last one is the same as the previous one to group. An exampleCopy codeThe Code is as follows: $ result = mysql_query ("SELECT groups, name, goods FROM table group by groups, name order by name ");
$ Arr = array ();
$ I = 0;
While ($ row = mysql_fetch_array ($ result )){
$ Arr [] = $ row;
}

$ M = $ I-1;
Foreach ($ arr as $ k =>$ v ){
If ($ v [$ I] ['groups'] <> $ v [$ m] ['groups']) {
Echo 'delimiter ';
}
Echo $ v ['name'], $ v ['goods '];
}