<p>The situation is as follows: I've got 2 models: 'Action' and 'User'. These models refer to the tables 'actions' and 'users', respectively.</p>

<p>My action table contains a column <code>user_id</code>. At this moment, I need an overview of all actions, and the users to which they are assigned to. When i use <code>$action-&gt;fetchAll()</code>, I only have the user ID, so I want to be able to join the data from the user model, preferably without making a call to <code>findDependentRowset()</code>.</p>

<p>I thought about creating custom <code>fetchAll()</code>, <code>fetchRow()</code> and <code>find()</code> methods in my model, but this would break default behaviour.</p>

<p>What is the best way to solve this issue? Any help would be greatly appreciated.</p>

You could always make a view in your database that does the join for you.
```
```
CREATE OR REPLACE VIEW VwAction AS
SELECT [columns]
  FROM action
  LEFT JOIN user
    ON user.id = action.user_id
```
```
Then just use
```
```
$vwAction->fetchAll();
```
```
Just remember that views in MySQL are read-only (assuming this is MySQL)