jucai/app/Models/CategoryMajor.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
/**
 * App\Models\CategoryMajor
 *
 * @property int $id
 * @property int $parent_id 父类ID
 * @property string $name 名称
 * @property int $order 排序
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property string|null $deleted_at
 * @method static bool|null forceDelete()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor newQuery()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryMajor onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor query()
 * @method static bool|null restore()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereOrder($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereParentId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryMajor whereUpdatedAt($value)
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryMajor withTrashed()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryMajor withoutTrashed()
 * @mixin \Eloquent
 */
class CategoryMajor extends Model
{
    use  SoftDeletes;

    protected $table = 'category_majors';
    protected $guarded = [];
    
    public function children()
    {
        return $this->hasMany(CategoryMajor::class, 'parent_id')->orderBy('order','desc');
    }
    public static function category($str)
    {
        return array_column(CategoryMajor::where('parent_id', $str)->get(['id',"name"])->toArray(), 'name', 'id');
    }
    
}