I had a look on your database design
Context I understood :
The 2 FK references to users are located in the EXPERTSTOJOBS table. N:1 relation
You want to list the users from the Jobs table.
Since ORM, this is incredibely simple to achieve.
This should work to grab the datas.
$this->orm(array(
'relation' => array(
'xexpertstojobs' => array(
'select' => array(
'expert_id.username',
'expert_id.name',
'referrer_id.username',
'referrer_id.name',
)
)
)
));
Then dump the loaded datas, and you will see the list of users behind the N:1 relation.
Need more explanation ?
EDIT : You need to download again because I fixed something on the ORM engine that was required for this operation.
