Small Question

[eluser]robertGM[/eluser]
I jest wanted to ask how can i transform this query in CI :

$sql="SELECT * FROM users WHERE id IN (SELECT DISTINCT $coloana FROM $table) ORDER BY username ASC";


$this->db->select()
->from('users')
->where('id' ??? )
->order_by('username ASC');


Thanks