使用laravel DB:：raw和groupBy months从两个不相关的表中减去两个Sumed变量

首先从财务模型组按月获得成本之和第二个从会计模型组按月获得存款之和第三个查找存款与成本和组之间的减法按月

$data1=财务：：选择(

        \DB::raw('SUM(cost) as finances_monthly'),
        \DB::raw('(unit) as unit'),
        
        \DB::raw("DATE_FORMAT(date,'%M %Y') as months"))
        
      ->where('unit', '=', $unit)
    ->whereBetween('date', [$start_date, $end_date])
    ->orderBy('date','asc')
    ->groupby('months','unit')->get();

//按月从财务模型和组中获取成本总和

$data2=$MonthlyPayments=会计：：select(

      \DB::raw('SUM(deposite) as deposites_monthly'),
      \DB::raw('(unit) as unit'),
    
      \DB::raw("DATE_FORMAT(payment_date,'%M %Y') as month"))
      
  ->where('unit', '=', $unit)
  ->orderBy('created_at','asc')
  ->whereBetween('payment_date', [$start_date, $end_date])
  ->groupby('month','unit')->get();

//从Accountings模型中获取存款总额，并按月份分组

这里的问题是如何从finances_monthly和groupBy months中减去deposites_mmonthly