Laravel Eloquent 多对多关系中获取指定列数据并格式化为数组

{
  "id": 1,
  "name": "harat",
  "skills": [
    "php",
    "laravel",
    "reactjs",
    "nodejs"
  ]
}

// app/Models/Person.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Person extends Model
{
    protected $table = 'person_table'; // 如果表名不是复数形式，需要指定

    public function skills(): BelongsToMany
    {
        return $this->belongsToMany(Skill::class, 'person_skill_table', 'person_table_id', 'skills_table_id');
    }
}

// app/Models/Skill.php
namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Skill extends Model
{
    protected $table = 'skills_table'; // 如果表名不是复数形式，需要指定

    public function people(): BelongsToMany
    {
        return $this->belongsToMany(Person::class, 'person_skill_table', 'skills_table_id', 'person_table_id');
    }
}

use App\Models\Person;

// 获取所有人员及其关联的技能
$people = Person::with('skills')->get();

// 如果只需要获取单个人员
// $person = Person::with('skills')->first();

use App\Models\Person;

$people = Person::with('skills')->get()->map(function (Person $person) {
    return [
        'id' => $person->id,
        'name' => $person->name_of_person, // 注意这里使用数据库字段名
        'skills' => $person->skills->pluck('name_of_skill')->toArray(), // 提取技能名称并转换为数组
    ];
});

// 如果只需要获取单个人员
// $person = Person::with('skills')->first();
// $formattedPerson = [
//     'id' => $person->id,
//     'name' => $person->name_of_person,
//     'skills' => $person->skills->pluck('name_of_skill')->toArray(),
// ];

// $people 现在是一个包含所需格式数据的集合
// 可以将其转换为 JSON 响应
// return response()->json($people);

php artisan make:resource PersonResource

// app/Http/Resources/PersonResource.php
namespace App\Http\Resources;

use Illuminate\Http\Resources\Json\JsonResource;

class PersonResource extends JsonResource
{
    /**
     * Transform the resource into an array.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return array
     */
    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'name' => $this->name_of_person,
            'skills' => $this->whenLoaded('skills', function () {
                return $this->skills->pluck('name_of_skill');
            }),
            // 或者直接：
            // 'skills' => $this->skills->pluck('name_of_skill'),
        ];
    }
}

use App\Models\Person;
use App\Http\Resources\PersonResource;

class PersonController extends Controller
{
    public function index()
    {
        $people = Person::with('skills')->get();
        return PersonResource::collection($people);
    }

    public function show(Person $person)
    {
        $person->load('skills'); // 确保技能关系被加载
        return new PersonResource($person);
    }
}