How to write this SQL statement in Active Record

[eluser]Isamtron[/eluser]
Hello,

How to write this SQL statement in Active Record:

Code:

$this->db->query('SELECT a.slogan, a.brief, u.id, u.name FROM example_tbl AS a, users AS u WHERE u.user_id = "' . USER_ID . '"');

Please help. Thanks.