Hi @Siqing Zheng ,
Thanks for detailed case scenario.
Currently you cannot use Managed identities across tenants as mentioned here. The solution for you would be to use a Service principal for now.
I would suggest you post this idea at the Azure Feedback Portal, which is monitored by the product team for feature enhancements.
Hope this will help.
Thanks,
Shweta
Please remember to "Accept Answer" if answer helped you.