You didn't need name, that only complicates things, but in any case, you needed to do "LEFT JOIN"s instead of the "JOIN's.

SELECT statuses.status, tags.tag FROM statuses LEFT JOIN statuses_tags ON statuses.id = statuses_tags.status_id LEFT JOIN tags ON statuses_tags.tag_id = tags.id;