Select Where In Join

Select Where In Join

I want to get results from ids i already know. This is my attempt(pseudo):
SELECT * FROM main LEFT JOIN child WHERE main.id IN("1,2,3,4") ON main.id
= child.main_id
How to get the childs from main by known ids from WHERE IN?
thx for help