PDO: get list

ModelTable.php

        //$list = array();
        $sql = "
            select
                * #fields
            from
                table
            WHERE
              id = :id
        ";
        $query = $this->get('pdo')->prepare($sql);
        $query->execute(array(':id' => $id));

        while ($r = $query->fetch(\PDO::FETCH_ASSOC)) {
            //$list[$r['id']] = $r;
        }