get last id in mysql codeigniter code example

Example: how to get last id in database codeigniter 4

$db = db_connect();
  $query = $db->query("SELECT * FROM users ORDER BY id DESC LIMIT 1");
  $result = $query->getRow();