how to get the last used id in a database code example

Example: how to get last id in database

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