Add in a new table into my query

Hi,

In my payments model I have created a relationship belongsTo for my donate_messages table on payment.id

I would now like to bring through 'MESSAGE' into the Payment query below

Thanks

$query = Payment::whereIn('type', ['subscription', 'purchase'])->where('campaign_id', '=', $campaign_id)->active();

Level 102

How do you want it in there? Do you mean you wish to load the relationship? Or restrict the results by the relationship?

Level 7

I have tried passing in:

->with('message')

Level 102

That sounds correct. And the problem with that is?

Level 7

I just want to load in the relationship into payments so the message object from the donation_message table will be available on payment.id

Level 7

any help here much appreciated

Please or to participate in this conversation.