Laravel，获取关系行而不是id

Question

我想获取作者行而不是author_id。我可以通过添加集合并一一更改来实现这一点，但是 Laravel 有这方面的功能吗？好吧，我想让这一行 我可以使用这样的

Book::where('id',$bid)->with('author')->first('author_id AS author'); //Changes only coulmn name :(

模型

public function author()
    {
        return $this->hasOne(Author::class,'id','author_id');
    }

查询

Book::where('id',$bid)->with('author')->first()

输出

  {
    "id": 1,
    "name": "Book 1",
    "author_id": 3,
    "category_id": 2,
    "level_id": 1,
    "book_language_id": 1,
    "book_length": 0,
    "img": "book1.png",
    "summary": "Summary 1",
    "rate_avg": "2.75",
    "created_at": "2022-03-04T18:46:32.000000Z",
    "updated_at": "2022-03-04T18:52:28.000000Z",
    "author": {
        "id": 3,
        "name": "Author 3",
        "created_at": "2022-03-04T18:46:32.000000Z",
        "updated_at": "2022-03-04T18:46:32.000000Z"
    }
}

想要

{
    "id": 1,
    "name": "Book 1",
    "author": {
        "id": 3,
        "name": "Author 3",
        "created_at": "2022-03-04T18:46:32.000000Z",
        "updated_at": "2022-03-04T18:46:32.000000Z"
    },
    "category_id": 2,
    "level_id": 1,
    "book_language_id": 1,
    "book_length": 0,
    "img": "book1.png",
    "summary": "Summary 1",
    "rate_avg": "2.75",
    "created_at": "2022-03-04T18:46:32.000000Z",
    "updated_at": "2022-03-04T18:52:28.000000Z",
    
}

Answer 1

在您的查询中，

Book::where('id',$bid)->with('author')->first()

您将获得具有该 id 的书籍，并且您渴望加载作者关系，因此为了获取作者，您必须访问作者字段：

Book::where('id',$bid)->with('author')->first()->author

Answer 2

正如我所说，我可以这样收集：

$b=Book::where('id',$bid)->with('author')->first();

                    $book=collect([
                        'id'=>$b->id,
                        'name'=>$b->name,
                        'author'=>$b->author,
                        'category_id'=>$b->category_id,
                        'level_id'=>$b->level_id,
                        'book_language_id'=>$b->book_language_id,
                        'book_length'=>$b->book_length,
                        'summary'=>$b->summary,
                        'rate_avg'=>$b->rate_avg,
                    ]);

但这种方法似乎没有必要

Answer 3

在您的示例中，输出和您想要的之间的唯一区别是“author_id”：3，已被删除。

因此，如果您不需要列或重命名列，则需要使用 ->select 并获取您想要的所有字段。你也可以用类似的东西重命名

-> select(DB::raw('author_id as auhtor'), 'books.*')