Kohana 3.x: SQL-Query for Entities and all their Members -

i use kohana 3.x. have simple query retrieve objects mysql database:

$query = db::query(database::select, "select * myentity foreignkey = {$myforeignkey};"); $result = $query->execute($this->database); $resultarray = $result->as_array(); 

it works expected. $resultarray contains many objects there entitys matching query. each object within $resultarray dictionary, containing properties kex-value-pairs.

but each "myentity" member-attributes! right i'm using php-for-loop so:

foreach ($resultarray $entity) {   $query = db::query(database::select, "select * member foreignkey = {$entity['id']};");   $result = $query->execute($this->database);   $memberarray = $result->as_array();   // memberarray..   } 

i guess stupid sql-query each "myentity" object, , rather 1 query "myentities" plus members each of "myentities". how can that?

can try , see if produce result want?

select * myentity join member on member.foreignkey = myentity.foreignkey myentity.foreignkey = {$myforeignkey};