如何从 2 个表创建嵌套的 json 对象查询？

Question

我需要做出一个json看起来像这样的结果{"data":[    {"id":2,    "name":"miles",    "email":"[e-mail]",    "details":{        "id":11,        "product_id":"product-003","purchase_rebate":2,        "purchase_rebate_date":"2019-09-10 23:07:33",        "survey_ans_rebate":2,"survey_ans_rebate_date":"2019-09-10 23:07:33",        "created_at":"2019-09-10 23:07:33","updated_at":"2019-09-10 23:07:33"        },    },    {"id":3,    "name":"Jayson",    "email":"[e-mail]",    "details":{        "id":13,        "product_id":"product-010",        "purchase_rebate":2,        "purchase_rebate_date":"2019-09-11 04:26:24",        "survey_ans_rebate":2,        "survey_ans_rebate_date":"2019-09-11 04:26:24",        "created_at":"2019-09-11 04:26:24",        "updated_at":"2019-09-11 04:26:24"}    }    ]}这是我的服务器端 PHP 脚本$get_merchant_users = DB::table('merchant_users as a')            ->leftjoin('user_transactions as b', 'b.email','=','a.email')             ->select('a.id','a.name',DB::raw('SUM(b.purchase_rebate) + SUM(b.survey_ans_rebate) as total'),'a.email')            ->groupBy('a.id','a.name','a.email')                     ->get();            $details = DB::table('user_transactions')            ->select('*')            ->get();            $data = array('data'=> $get_merchant_users,'details'=> $details);            return $data;