GROUP BY and get the columns values into single row column

i was thinking if possible to get all the values of using GROUP BY room. example i have a tables named subject , room and classroom

table subject

   subject_id | subject_name
    -------------------
        1     | math
        2     | science
        3     | english

table room

    room_id | room_name
   -------------------
       1    | sunflower
       2    | cornflower
       3    | redflower

table classroom

    id | room_id | subject_id 
   -------------------
    1  | 1       | 1          
    2  | 1       | 2
    3  | 1       | 3

now the query. not sure if the query im used was correct or enough querying.. but the outputed query show expecting not that

SELECT * FROM classroom 
LEFT JOIN subject ON classroom.subject_id = subject.subject_id
LEFT JOIN room ON classroom.room_id = room.room_id 
GROUP BY room_name

now the output i want to expecting like this

classroom

room_name | subject_name 
------------------------
sunflower | math
          | science
          | english

it should grouping by sunflower into one row column

from Recent Questions - Stack Overflow https://ift.tt/3u2QaQp
https://ift.tt/eA8V8J