在數(shù)據(jù)填充時遇到問題，之前都是采用隨機數(shù)據(jù)填充，使用 laravel 模型工廠以及 Faker\Generator 生成隨機數(shù)據(jù)。非常方便。但是我想在程序初始化時，填入一些由我提供的數(shù)據(jù)，而非隨機數(shù)據(jù)。

假設(shè)：我提供的數(shù)據(jù)為 $name。我有兩張表，categories 和 navigations ，兩張表存在關(guān)聯(lián)關(guān)系，navigations.category_id 對應(yīng) categories.id 。我的想法如代碼所示，雖然能成功寫入數(shù)據(jù)，但是感覺不好，感謝大佬們提供思路。

代碼如下：

<?php

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class CategoryTableSeeder extends Seeder
{
    protected $name = [
        'php'      => [
            [
                'name'     => 'php1',
                'describe' => 'php1',
                'icon'     => 'php1'
            ], [
                'name'     => 'php1',
                'describe' => 'php1',
                'icon'     => 'php1'
            ], [
                'name'     => 'php1',
                'describe' => 'php1',
                'icon'     => 'php1'
            ],
        ], 'mysql' => [
            [
                'name'     => 'mysql1',
                'describe' => 'mysql1',
                'icon'     => 'mysql1'
            ], [
                'name'     => 'mysql1',
                'describe' => 'mysql1',
                'icon'     => 'mysql1'
            ], [
                'name'     => 'mysql1',
                'describe' => 'mysql1',
                'icon'     => 'mysql1'
            ],
        ], 'vue'   => [
            [
                'name'     => 'vue1',
                'describe' => 'vue1',
                'icon'     => 'vue1'
            ], [
                'name'     => 'vue1',
                'describe' => 'vue1',
                'icon'     => 'vue1'
            ], [
                'name'     => 'vue1',
                'describe' => 'vue1',
                'icon'     => 'vue1'
            ], [
                'name'     => 'vue1',
                'describe' => 'vue1',
                'icon'     => 'vue1'
            ], [
                'name'     => 'vue1',
                'describe' => 'vue1',
                'icon'     => 'vue1'
            ],
        ],
    ];

    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run ()
    {
        foreach ($this->name as $key => $value) {
            $id = DB::table('categories')->insertGetId([
                'name'       => $key,
                'type'       => '1',
                'created_at' => \Carbon\Carbon::now()->toDateTimeString(),
                'updated_at' => \Carbon\Carbon::now()->toDateTimeString(),
            ]);
            foreach ($value as $k => $v) {
                DB::table('navigations')->insert([
                    'category_id' => $id,
                    'name'        => $v['name'],
                    'describe'    => $v['describe'],
                    'icon'        => $v['icon'],
                    'created_at'  => \Carbon\Carbon::now()->toDateTimeString(),
                    'updated_at'  => \Carbon\Carbon::now()->toDateTimeString(),
                ]);
            }
        }

    }
}