Maternal COVID-19 infection increases the incidence of neurodevelopmental disorders (NDDs) in offspring, although the underlying mechanisms have not been elucidated. This study demonstrated that COVID-19 infection during pregnancy disrupted the balance of maternal and fetal immune environments, driving alterations in astrocytes, endothelial cells, and excitatory neurons. A risk score was established using 47 unique genes in the single-cell transcriptome of gestational mothers. The high risk score in CD4 proliferating T cell level served as an indicator for increased risk of offspring NDDs. Summary-based Mendelian randomization and phenome-wide association study analyses were conducted to identify the causal association of the transcriptional changes with the increased risk of offspring NDDs. Additionally, 10 drugs were identified as potential therapeutic candidates. Our findings support a model where the maternal COVID-19 infection changed the levels of CD4 proliferating T cells, leading to the alterations of astrocytes, endothelial cells, and excitatory neurons in offspring, contributing to the increased risk of NDDs in these individuals.