how can i write this query

What you also can do to make it easier for you:

$query = "your query here.";
$this->db->query($query);