related foreign key to own table

how to go through childrens specified in same table?

for example:

table
people (id, name, children_id), children_id is foreign key to people id
1, František Horák, NULL
2, Anička Horáková, 1
3, Pepíček Horák, 1

		$query = $this->database->table('people');
		$query->select('people.*');
		$query->where('children_id IS NULL');

	foreach($query as $someone) {
		echo $someone->name . "\n";

		foreach($someone->related('children') as $someoneChild) {
			echo " has child: " . $someoneChild->name . "\n";
		}
	}

problem:

No reference found for $people->related(children).

Last edited by mcmatak (2015-04-15 15:23)