title: Adding additional data to select query result
body: <p>I am fetching data from Articles table but I want to extend returned result with some data from another table. 
  For example: </p>
  
  <pre><code>public function getArticlesByCategoryId($category_id = 0) { 
      $select = $this-&gt;_db-&gt;select()
              -&gt;from($this-&gt;_name)
              -&gt;limit(5)
              -&gt;order("pubDate DESC");
  
      $result = $this-&gt;_db-&gt;fetchAll($select);
  
      $mCategories = new Model_Categories();
  
      foreach($result as $row) { // as &amp;$row doesn't work
          $category_name = $mCategories-&gt;getNameById($row["category_id"]);
          $row["category_name"] = $category_name; // this to add to $result but dunno how 
          // blah blah...
      } 
  
      return $result; // the new one with ...-&gt;category_name in it.
  }
  </code></pre>
  
  <p>I hope you could understand what I am looking for. 
  Or maybe it is better to write a single query (with joins, don't know how) and fetch all the data needed in once without calling methods from another Models? </p>