In-Table Foreign Keys in DataMapper ORM

[eluser]tarciozemel[/eluser]
With the help of my pal, I did this works! I had to use “join_self_as” in user model even that not have an FK in the other table. So, the solution is:

user_model.php (class User_model)

Code:

var $has_one = array(
    'user_group' => array(
        'class' => 'user_group_model',
        'other_field' => 'user',
        'join_other_as' => 'group',
        'join_self_as' => 'user'
    )
);

user_group_model.php (class User_group_model)

Code:

var $has_many = array(
    'user' => array(
        'class' => 'user_model',
        'other_field' => 'user_group',
        'join_other_as' => 'user',
        'join_self_as' => 'group'
    )
);

I think DataMapper documentation should have more examples, especially in the "Advanced Relationships" section. This would greatly will help people! :-D

Very thank you for you help and congratulations for the DataMapper!