As you have no doubt already discovered, preposition use in English is often highly idiomatic. You will need to show the sentences that are causing confusion to know which ones to use. Very generally: This is a painting by my mother - my mother painted it.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.