ALTER TABLE users ADD COLUMN first_name VARCHAR(255);
ALTER TABLE users ADD COLUMN last_name VARCHAR(255);

UPDATE users SET first_name = LEFT(name, LOCATE(' ', name)-1) WHERE first_name IS NULL;
UPDATE users SET last_name = RIGHT(name, LENGTH(name) - LOCATE(' ', name)) WHERE last_name IS NULL;