DB Query Builder to Resource

Hi Guys,

Sorry if this sound dumb but I have not used DB query builder extensively and used eloquent most of the time.

I have this requirement where I want to use query builder along with several joins etc.

so my query looks like this so far

  [
  {
     "user_id": 20,
     "first_name": "Zeeshan",
     "last_name": "Sabri",
     "email": "[email protected]",
     "phone": null,
     "id": 1,
     "model_type": "test",
     "model_id": 20,
  },
 {
     "user_id": 20,
     "first_name": "Zeeshan",
     "last_name": "Sabri",
     "email": "[email protected]",
     "phone": null,
     "id": 2,
     "model_type": "test,
     "model_id": 20,
  },
]

But what I do what is this

[
  {
     "user_id": 20,
     "first_name": "Zeeshan",
     "last_name": "Sabri",
     "email": "[email protected]",
     "phone": null,
     "models": {
      "id": 1,
       "model_type": "test",
        "model_id": 20,
       },
       {
       "id": 2,
       "model_type": "test2",
        "model_id": 20,
       },
]

I understand I can get to that using loop but before I do that I want to check with you geniuses here that is there a proper way of doing this?