Add wp_query loop to cpt admin screen

I have a cpt of “clients” and one of “orders.” I will most likely link them with a custom taxonomy based on the client’s name. I want to be able to add a custom loop to the *admin screen for the “client” cpt, that shows a list of the “orders” that area assigned to that particular client.

A sample URL of where I want this, for example, would be:
http://playground-site.local/wp-admin/post.php?post=24&action=edit

What is the best way of adding this? I assume it should be a plugin, but I’m not sure how the templating for the admin screens works. I’m very familiar with the front-end theme/template pages though.

My “client” cpt only uses the default title field, the rest of the fields are ACF fields and the default editor is not necessary. I’d like to either show this list of “orders” in the sidebar or underneath the custom fields set to show on the “client” cpt.

Any advice is welcome, or if you could point me in the correct direction. I can not find much on customizing the admin area screens.