I was having the same problem with a 2011 R56 that I just purchased, I bought this cable but haven’t tried it yet. Looking at people’s other posts I’m worried this will not work since it’s considerably cheaper.

[Upgraded ] 2 in 1 Audio Charging Cable Compatible with iPhone/iPad, Charge and Play Music Simultaneously Support to Car Stereo/Speakers/Headphone with 3.5mm Audio Jack, 3.94Ft (White) https://www.amazon.com/dp/B08CY4CFLG/ref=cm_sw_r_cp_api_glc_fabc_g3VaGbP30Z7R6?_encoding=UTF8&psc=1