ALTER TABLE orders
ADD COLUMN user_id INT NULL,
ADD CONSTRAINT fk_order_user
FOREIGN KEY (user_id) REFERENCES users(id)
ON DELETE SET NULL;