How to relation with two table when column value is a array in Laravel

Question

I need all reports with all officers included in the participants column.

please check the attached image.

score 0 · Accepted Answer · answered Sep 10 '22 at 18:24

0

You should really have a participant pivot table with report_id and officer_id, and create proper relationships.

What you're asking for is possible through loops and lazy loading, but it will be extremely slow and unoptimized.

answered Sep 10 '22 at 18:24

kjoedion

1 Answers1