[PHP] Nested_Sets addSQL question

[T.H. Boonstra]

Hi all,

I'm having a problem with the Nested Sets package,
I want to use the addSQL function to retreive extra information from a
different table, now my query works, however new columns aren't returned :(

I hope anyone knows how to retreive them?

Here is my (test) SQL statement:

$addSQL = array(
        'cols' => 'category.creator',
        'join' => 'LEFT JOIN category ON
pw1_category.name=category.categoryname_en',
        'where' => 'pw1_category.name=category.categoryname_en',
        'append' => 'GROUP by category.categoryname_en');

 $categorys = $nestedSet->getChildren($_GET['id'],true,true,false,$addSQL);


All columns i have specified in the $factory $params work perfectly but i
can't add my new category.creator field because it will then automaticly add
the first tablename in front of it :(

Any help is appriciated..

Greetings Tim