I am sorry that I cannot answer your question directly.
When I applied to universities in the US (I went to MIT for my bachelor’s degree) my “foreign language” was French. This might seem foreign to some people. However, I was applying to MIT as an international student from Montreal. French is definitely not a foreign language in Montreal. Universities in the US seemed to think that it was foreign enough for them.
This might suggest that taking a class in Mandarin might be sufficient in your case. However, you might want to see whether your academic advisor or a transfer advisor at your community college agrees.
One thing that might be worth adding: My understanding is that universities look at the highest level achieved in a foreign language. I don’t think that you need to take many years of it. I would expect that you would start with a course that is intended for someone who already speaks some Mandarin, so you could achieve a sufficiently “high level” quickly. I do not know whether you would actually need to take a class at all.