如何在SQLAlchemy中按混合属性对具有两次对同一表的引用的一对一关系进行排序？

from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    address_id = Column(Integer, ForeignKey('addresses.id'))
    billing_address_id = Column(Integer, ForeignKey('addresses.id'))

    address = relationship("Address", foreign_keys=[address_id])
    billing_address = relationship("Address", foreign_keys=[billing_address_id])

class Address(Base):
    __tablename__ = 'addresses'
    id = Column(Integer, primary_key=True)
    street = Column(String)
    city = Column(String)
    state = Column(String)

# 在查询时，可以使用order_by参数对关系进行排序
users = session.query(User).order_by(User.address_id, User.billing_address_id).all()