laravel 查询构造器 两表联查 A表多个字段关联一个B表一个字段

$data = DB::table('draft_sound as a')
                ->select('a.dialect_name','b.name as province_name','c.name as city_name','d.name as district_name','a.file_name')
                ->join('china_area as b','a.province_id','b.code')
                ->join('china_area as c','a.city_id','c.code')
                ->join('china_area as d','a.district_id','d.code')
                ->whereRaw('a.resources_id = ? and a.deleted_at is null',[$resources_data->id])
                ->get();
 

获取sql语句

       DB::connection()->enableQueryLog();
        
        $data = DB::table('test')->get()

        print_r(DB::getQueryLog());