Six people - four adults and two children - have died in a crash between Wakefield and Barnsley.