By the first three petitions, we are strengthened in faith, filled with hope, and set aflame by charity. Being creatures and still sinners, we have to petition for us, for that "us" bound by the world and history, which we offer to the boundless love of God. For through the name of his Christ and the reign of his Holy Spirit, our Father accomplishes his plan of salvation, for us and for the whole world. CCC 2806
It contains seven petitions made to God the Father. The first three, more God-centered, draw us toward him for his glory; it is characteristic of love to think first of the beloved. These petitions suggest in particular what we ought to ask of him: the sanctification of his Name, the coming of his Kingdom, and the fulfillment of his will. The last four petitions present to the Father of mercies our wretchedness and our expectations. They ask him to feed us, to forgive us, to sustain us in temptations, and to free us from the Evil One. (#587)
The Catechism Companion Vol III has some good commentary on this:
The three petitions at the beginning of the Lord's Prayer are focused on loving God first. The initial petitions - "Hallowed be thy name. Thy kingdom come. Thy will be done on earth as it is in heaven" - emphasize that we must reorient our hearts toward God and prioritize his glory. The final four petitions are categorized into two sets: those concerning daily life and those addressing the struggle for eternal salvation. The Lord's Prayer is transformative, enabling us to love God more than we love ourselves. A plea for assistance in daily tasks, forgiveness, and the pursuit of the heavenly goal is expressed through the petitions. In Jesus and by the power of the Holy Spirit. God the Father saves us. (p. 234)