How can i make model query based on images

In CI it is much easier.

PHP Code:

$query=$this->db->query("SELECT * FROM table ORDER BY id DESC LIMIT 4"); 


To display the first row (your latest article):

PHP Code:

$main_article = $query->row(0); 


To display the next article at the top your right column:

PHP Code:

$topright_article = $query->row(1); 


To display the next 2 items:

PHP Code:

for ($x=3; $x<5; $x++) {
  $right_article[] = $query->row($x);
} 


If you want to do this in a model, make your model return the $query object.