As dynamic group is based in membership criteria. AFAIK there is no such direct criteria for Primary databases but you can use existing criteria say "Line of business" and call it Standby and use this value to create a dynamic group. This is a work around.
Thank you for the update, but if we do switchover will the group get updated that it is not primary or standby database.
Good question. I do not think so.