how to get another column same value for the increment culomn

i have column call id is increment auto in DB how to get another column same value?

EX:

$sql = 'insert into villa (id,vid)
     values(:itid,:itvid)';

     $stmt->execute($r = array(
            'itid'                       => null,
            'itvid'=>id));

i am not sure about this because it is not work