It depends on the sentence. They are both used. They have the same meaning, essentially. What is your sentence?
JOIN WITH US is "grander" as in:
"JOIN WITH US IN THE STRUGGLE!". (strike, revolution, petition)
JOIN US FOR DINNER! or Why don't you JOIN US FOR A MOVIE?