How to query three tables and return json?

Question

MySQL

There are three tables: users, playlists, tracks. Playlists can be shared, and one track can be in different playlists. I'm trying to return user information and playlists with tracks in one json.
First, I made such a database structure with two pivot tables:

However, I could not formulate a normal query so that both the user's playlists and the tracks to them would be displayed with one query. There was an idea to take the user's playlists and make separate requests for tracks in a loop, but it seemed to me that it smelled like shitcode and this idea was discarded.
Then I remade the database into this:

It works, but json is flat single-level, but I want it with nested objects.
The first variant of the database seems to be good until I returned it back.
We need advice on how to correctly formulate a request for it, and any other decisions are made.
DBMS - MySQL, Laravel PHP, Eloquent ORM.

Answer 1

Which array you pass to json_encode() - you will get such JSON. If you don't want a flat one, pass the nested one, it doesn't care.