how to laravel join json format

sql query like this, My query works like this but how can I get a simpler output?;