DMZ (Datamapper) quick query question

[eluser]kungpoo[/eluser]
This seems to be more like what I want

Code:

$s = new Student($id);
$s->course->select('name');
$s->course->get_iterated();

foreach ($s->course as $c) {
    echo $c->name;
}

but still getting 2 select * limit 1 extra queries?

Code:

SELECT * FROM `students` LIMIT 1

SELECT *
FROM (`students`)
WHERE `students`.`id` = 1

SELECT * FROM `courses` LIMIT 1

SELECT `courses`.`name`
FROM (`courses`)
LEFT OUTER JOIN `courses_students` courses_students ON `courses`.`id` = `courses_students`.`course_id`
WHERE `courses_students`.`student_id` = 1