我在数据库上有2个表格

安加兰餐桌

+----+-------------------+
| id |      uraian       |
+----+-------------------+
|  1 | Pembangunan Jalan |
|  2 | Material Bangunan |
+----+-------------------+

表Pengeluaran

+----+-------------+------------+---------+----------+
| id | anggaran_id |   waktu    | jumlah  | penerima |
+----+-------------+------------+---------+----------+
|  1 |           2 | 2019-10-12 | 1000000 | Dadang   |
|  2 |           2 | 2019-10-28 | 1500000 | Bambang  |
|  3 |           2 | 2019-11-12 | 3000000 | Tono     |
|  4 |           2 | 2019-12-10 | 2500000 | Agus     |
|  5 |           2 | 2019-12-20 | 1500000 | Bajo     |
+----+-------------+------------+---------+----------+

我想每月显示Pengeluaran表中所有带有sum jumlah的安加拉数据

我想要的结果在这里

+--------------------+---------+----------+------+-------+-----+------+------+--------+-----------+---------+----------+----------+
| Uraian             | January | February | March| April | May | June | July | August | September | October | November | December |
+--------------------+---------+----------+------+-------+-----+------+------+--------+-----------+---------+----------+----------+
|  Pembangunan Jalan |         |          |      |       |     |      |      |        |           |         |          |          |
|  Material Bangunan |         |          |      |       |     |      |      |        |           | 2500000 | 3000000  | 4000000  |
+--------------------+---------+----------+------+-------+-----+------+------+--------+-----------+---------+----------+----------+

我使用的代码有很多关系，但是总和没有显示

这里是我的控制器

$anggaran = Anggaran::with(['pengeluaran' => function($query){
          $query->select(
              DB::raw('sum(jumlah) as sum'),DB::raw("Monthname(waktu) as month"))
          ->groupBy('month');
         }])
        ->get();

这是我的刀片

@foreach($anggaran as $angaran)
      <tr>
        <td>{{$angaran->uraian}}</td>
        @foreach($angaran->pengeluaran as $p)
        <td>{{$p->sum}}</td>
        @endforeach
      </tr>
 @endforeach

我成功显示了uraian，但未出现总和。谁能帮我吗？