<?php
$host='HOST';
$bd='BD';
$user='USER';
$pass='PASSWORD';
 function makeAlias($str){

        $a = array(
                  '/[ÂÀÁÄÃ]/'=>'A',
                  '/[âãàáä]/'=>'a',
                  '/[ÊÈÉË]/'=>'E',
                  '/[êèéë]/'=>'e',
                  '/[ÎÍÌÏ]/'=>'I',
                  '/[îíìï]/'=>'i',
                  '/[ÔÕÒÓÖ]/'=>'O',
                  '/[ôõòóö]/'=>'o',
                  '/[ÛÙÚÜ]/'=>'U',
                   '/[ûúùü]/'=>'u',
                  '/ç/'=>'c',
                   '/Ç/'=> 'C',
                    '/\s/'=>'-');
        return preg_replace(array_keys($a), array_values($a), $str);

    }

$mysqli = new mysqli($host, $user, $pass,$bd);
if (mysqli_connect_errno()) {
    $mysqli->close();
    exit('Erro ao conectar');
}
$res = $mysqli->query("SELECT `id`,`nome` FROM `pessoa`");
while ($row = $res->fetch_assoc()) {
    $query='UPDATE `pessoa` SET `apelido`=\''.makeAlias($row['nome']).'\' WHERE `id`=\''.$row['id'].'\'';
    $mysqli->query($query);
}
$mysqli->close();