$this->template->users = $users = $this->db->select('*, user.id as user_id')->from('napad')
        ->innerJoin('user')->on('napad.id_user = user.id')
    ->fetchAssoc('user_id[]');


//latte

{foreach $users as $userId => $ideas}
<tr><td>ID uživatele {$idea->user_id}</td></tr>

<tr n:foreach="$ideas as $idea">
  <td>Nápad {$idea->nazev}</td>
</tr>
{/foreach}