Profile Model:
id
name

Job Model:
id
client_id
description

Offer Model:
id
job_id
price

public function offers()
    {
        return $this->hasManyThrough(Offer::class, Job::class, 'client_id', 'job_id', 'client_id', 'id');
    }

>>> $p = Profile::find('H5JJ44HLK545SKDJ');
=> AppProfile {#1018
     id: "H5JJ44HLK545SKDJ",
     password: "$2y$10$4wvysfaqc.vwnabKsHOnnOpXJlIp.kTLgOD2jViOTVH9JAXj4qxtO",
     name: "TestName",
}
>>> $p->offers()->toSql();
=> "select * from `offers` inner join `jobs` on `jobs`.`id` = `offers`.`job_id` where `jobs`.`client_id` is null"