@Matt Dodges的回答使我走上了正确的轨道。再次感谢您提供所有答案,在此期间,这对很多人都有所帮助。像这样工作:
SELECt *FROM feeds fLEFT JOIN artists a ON a.artist_id = ( SELECt artist_id FROM feeds_artists fa WHERe fa.feed_id = f.id LIMIT 1)WHERe f.id = '13815'

@Matt Dodges的回答使我走上了正确的轨道。再次感谢您提供所有答案,在此期间,这对很多人都有所帮助。像这样工作:
SELECt *FROM feeds fLEFT JOIN artists a ON a.artist_id = ( SELECt artist_id FROM feeds_artists fa WHERe fa.feed_id = f.id LIMIT 1)WHERe f.id = '13815'