sql select na základě předešlého insertu v php pdo

$sql = "INSERT INTO users VALUES(0,'".$this->data["jmeno"]."','".$this->data["user"]."',SHA1('".$this->data["pass"]."'),'".$this->data["aktivni"]."','');";
$sql.= "SET @id = LAST_INSERT_ID();";
if( isset($this->data["farn"])){
    foreach ($this->data["farn"] as &$value) {
    $sql.= "INSERT INTO adminis VALUES (@id,".$value.");";
   }
}
$ip = gethostbyname($_SERVER['REMOTE_ADDR']);
$sql.= "INSERT gdpr VALUES ('ducho',NOW(),@id,'$ip',".$_SESSION['user_id'].",'vloženo');";

$sql.= "SELECT MAX(id) AS id FROM users;";
$result= self::$connect->query($sql);
$result->fetchAll(PDO::FETCH_ASSOC);
foreach($result as $row){
      $id= $row["id"];
}