db={"playlists":[{"_id":{"$oid":"65e7a3006b0209462d08a5f5"},"playlist_name":"name of playlist","user_id":{"$oid":"65e3544e6b0209462d87f905"},"time":{"$date":"2024-03-05T17:56:00.286Z"},"tracks":[{"$oid":"65e7a2bd6b0209462d07d1d4"},{"$oid":"65e7a2bd6b0209462d07d1d3"}]}],"tracks":[{"_id":{"$oid":"65e7a2bd6b0209462d07d1d3"},"track_id":"500h8jAdr7LvzzXlm1qxtJ","album_name":"Thriller","artist_name":"Michael Jackson","track_name":"Beat It"},{"_id":{"$oid":"65e7a2bd6b0209462d07d1d4"},"track_id":"500h8jAdr7LvzzXlm1qxtK","album_name":"From The Album Of The Same Name","analysis":{"danceability":0.393,"energy":0.588,"key":9,"loudness":-6.68,"mode":0,"speechiness":0.0613,"acousticness":0.345,"instrumentalness":0,"liveness":0.134,"valence":0.728,"tempo":203.145,"analysis_url":"https://api.spotify.com/v1/audio-analysis/500h8jAdr7LvzzXlm1qxtK","duration_ms":186333,"time_signature":4},"artist_name":"Pilot","spotify":{"track_id":"500h8jAdr7LvzzXlm1qxtK","uri":"spotify:track:500h8jAdr7LvzzXlm1qxtK","track_href":"https://api.spotify.com/v1/tracks/500h8jAdr7LvzzXlm1qxtK"},"track_name":"Magic"}]}

db.playlists.aggregate([{"$lookup":{"from":"tracks","localField":"tracks","foreignField":"_id","as":"linkedTracks"}},{$set:{tracks:{$map:{input:"$tracks",as:"t",in:{$first:{$filter:{input:"$linkedTracks",cond:{$eq:["$$t","$$this._id"]}}}}}}}},{"$project":{"tracks.track_name":1,"tracks.artist_name":1,"tracks.album_name":1,"tracks.track_id":1,"user_id":1,"playlist_name":1}}])