The usual pattern in this case is to add first name and then all rest of the names in the first_name field. And last name in the last name field. Users can be made aware of this on the UI.

Another option is to create a middle_names or other_names field, its first_name then other_names then last_name in that order.