Online PHP editor | refs for Xf35f

<?php $ar = [["count"=>6,"year"=>2019,"month"=>10,"name"=>"P","id"=>3,], ["count"=>2,"year"=>2019,"month"=>10,"name"=>"s.vimal","id"=>1,], ["count"=>4,"year"=>2019,"month"=>10,"name"=>"MR","id"=>2,], ["count"=>11,"year"=>2019,"month"=>11,"name"=>"s.vimal","id"=>1,], ["count"=>1,"year"=>2019,"month"=>12,"name"=>"MR","id"=>2,], ["count"=>4,"year"=>2019,"month"=>11,"name"=>"vimaltest","id"=>10,], ["count"=>1,"year"=>2019,"month"=>12,"name"=>"vimaltest","id"=>10,]]; $mon_ar = array_unique(array_column($ar,'month')); $year_ar = array_unique(array_column($ar,'year')); foreach($ar as $rec){ foreach($year_ar as $year){ foreach($mon_ar as $month){ if (!isset($result[$year.$month])) $result[$year.$month] = [ 'month' => $month, 'year' => $year]; if ($rec['year'] == $year && $rec['month'] <= $month) { if (!isset($result[$year.$month][$rec['name']])) $result[$year.$month][$rec['name']] = 0; $result[$year.$month][$rec['name']] += $rec['count']; } } } } sort($result); print_r($result);