laravel-admin小技巧$grid显示序号和下级数量统计数字

这样搞可能会造成n+1问题

正如楼上说的, 你可以想像你有二十条数据, 那么就会执行二十次 CookFoodCuisines::where('food_id','=',$id)->count()

更好的做法是模型定义好关联关系

class CookFoods .... {
      public function cuisines()
      {
            return $this->hasMany(CookFoodCuisines::class, 'food_id');
      }
}

protected function grid()
    {
        $grid = new Grid(new CookFoods());

        $grid->model()->withCount('cuisines');

        $grid->number('序号');
        $grid->column('food_name','菜名');
        $grid->column('description','描述');
        $grid->column('tags','标签');
        // 直接使用 cuisines_count 字段
        $grid->column('cuisines_count','食材数')->style('text-align:center');
        $grid->column('created_at', __('Created at'));
        $grid->column('updated_at', __('Updated at'));
        $grid->rows(function ($row,$number){
           $row->column('number',$number+1);
        });

        return $grid;
    }