We actually use both in school and at school , for slightly different situations.
At school means the person is literally, physically, inside the school .
In school means the person is studying in general (usually at college or university) but not necessarily inside the school building at that moment.