How to make a selection in a grouped format?

Question

MySQL

There is a timetable with the class schedule

It is necessary to display the schedule of each group for the current day in this form

To get in this format from the database will not work, as far as I understand (an array with arrays of activities for each group).
Therefore, I have 2 options:
1. Iterate through all the groups, find the activities for each group for today
2. Iterate through all the activities for today, somehow make an array with groups out of this The
second option I think is more normal, but something tells me that there is better solution...

Answer 1

second option, yes. select all classes for today, sorted by group and start time. transfer to the view, draw from the list there as required.