I want to collect CPU usage for deployment distributed by namespace in Kubernets.

Now I am collecting as below.

enter image description here

But there are several deployment in namespace.

I want to collect cpu usage in the name of deployment, but I can't because the query of promql is difficult.

Is there anyone who can help?