how to delete from multiple tables using QB

hi everyone! how can rewrite the code below using pure QB without extending Query Builder Class?

PHP Code:

public function deny_email($user_id)
{
    $sql = 'DELETE  `users`, `users_temp`, `user_settings`
            FROM    `users`, `users_temp`, `user_settings`
            WHERE   `users`        .`user_id`       = '.$user_id.'
            AND     `users_temp`   .`utemp_user_id` = '.$user_id.'
            AND     `user_settings`.`uset_user_id`  = '.$user_id;

    return $this->db->query($sql);
} 


i have tried smth like this ->delete('user, users_temp, user_settings') n like this ->delete('user', 'users_temp', 'user_settings'), but the 1st query gives an error, the 2nd one works just for the first given table, i have also tried to pass 'em using array, but caught an error

thanks in advance!