A police officer who tried to urge his friend to take the blame after crashing his car in Wakefield while being nearly twice the drink drive limit has been jailed.