Controlador

 $data = DB::table('buses') ->join('bustypes', 'bustypes.id', '=', 'buses.bustype_id') ->select(DB::raw('bustypes.name as bustype'), DB::raw('COUNT(buses.id) as count')) ->groupBy('bustypes.id') ->get(); $array[] = ['Bustype', 'Number']; foreach ($data as $key => $value) { $array[++$key] = [$value->bustype, $value->count]; }

Espada

 <div class="panel-body" align="center"> <div id="pie_chart" style="width:450px; height:450px;"> </div> </div> <script type="text/javascript"> var analytics = <?php echo $company; ?> google.charts.load('current', {'packages': ['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable(analytics); var view = new google.visualization.DataView(data); var options = { title: "Car Own List" }; view.setColumns([0, { calc: "stringify", sourceColumn: 1, type: "string", role: "annotation" }, 1]); var chart = new google.visualization.PieChart( document.getElementById('pie_chart') ); chart.draw(data, options); } </script>