Yes, veins can collapse anywhere that people inject drugs, including the foot. Injecting into the foot is dangerous because the veins are smaller and more fragile, plus feet are sweaty and harbor bacteria that could lead to infection.
Shooting up in your feet is more difficult and more painful, but many addicts do it because they can more easily hide the marks left behind.