Laravel中数组的关系

Question

I have an author_id array. I want to fetch authors by IDs using relationship. I already fetched editions and publishers but the author has an array.

----------------------------------------------------------------------
| id | title            | author_id      | edition_id | publisher_id |
|----|------------------|----------------|------------|--------------|
| 2  | Web Development  | ["1","3","4"]  | 2          | 1            |
|----|------------------|----------------|------------|--------------|

Please check image:-

Please provide suggestions how can I get array column field in relationship

Answer 1

You should use a pivot table and a many-to-many relation to create this link correctly.

The new table would contain the author_id and the local_id. This way, a local row can have multiple authors and the relation can be defined in your database.