Problem with join

[eluser]Sein Kraft[/eluser]
This my code but it down't work properly because the user.id should be 24 and is returning the rank.id as user.id.

Code:

$query_users = $this->db
                            ->from('users')
                            ->join('roles', 'roles.id = users.role')
                            ->join('ranks', 'ranks.id = users.rank')
                            ->limit($limit, $offset)
                            //->order_by('u_date', 'desc')
                            ->get();

Array
(
[0] => Array
(
[id] => 1
[user] => seinkraft
[pass] => 55487196c2206c9345816936490688514f448edf
[email] => [email protected]
[activation_key] =>
[recovery_key] =>
[role] => Administrator
[rank] => Rank 1
[ip] => 127.0.0.1
[registered] => 1259933944
[last_visit] => 1259934493
[avatar] =>
[gender] => 0
[birthdate] => 0000-00-00
[location] =>
[signature] =>
[url] =>
[icq] =>
[aim] =>
[yim] =>
[msn] =>
)

)

Help please!