How to add an Array inside another Array from MySQL?

Question

SQL

I have a table with users, for example

id  |  username
------------------
1   |  user1
2   |  user2
3   |  user3
4   |  user4

And there is a table of blogs that users create

blog_id  |  user_id
------------------
1        |  1
2        |  1
3        |  3
4        |  3

and I have a code that pulls all users onto the page.

array =>
   {
      1 => user1,
      2 => user2
   }

but I need to add an array with a list of blogs of this user to these users inside the created array for each user

array =>
   {
      1 => user1 {
         array{
            blog1 => ...
            blog2 => ...
         }
      ,
      2 => user2 {
         array{
            blog4 => ...
            blog5 => ...
         }
      }
   }

Actually the question is how to organize such a structure in a human way?

Answer 1

According to my information, SQL does not work like that, if someone tells me a way, I will also be very grateful, I always had to get it separately and sort through 2 arrays already in php.

Answer 2

Everything is detailed here:
Official manual
Online article