let query = crate::bill_records::Entity::find()
        .join_as(sea_orm::JoinType::LeftJoin, super::bill_records::Relation::Depositor.def(), "depositor")
        .join_as(sea_orm::JoinType::LeftJoin, super::bill_records::Relation::Recorder.def(), "recorder")
        .into_partial_model::<super::bill_records::BillRecord>()
        .all(db)
        .await?;

bill_record.rs
#[derive(Debug, Deserialize, Serialize, Clone, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name="bill_records")]
pub struct Model {
        #[sea_orm(primary_key)]
        pub id: i64,
       // recorder
        #[sea_orm(nested, alias="recorder")]
        pub recorder_id: Option<i64>,
       // depositor
        #[sea_orm(nested, alias="depositor")]
        pub depositor_id: Option<i64>,
}

#[derive(Debug, Clone, Deserialize, Serialize, DerivePartialModel)]
#[sea_orm(entity = "Entity", from_query_result, into_active_model)]
pub struct BillRecord {
       pub id: i64,
       // recorder
        pub recorder: Option<super::member::Member>,
       // depositor
        pub depositor: Option<super::member::Member>,
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {
    #[sea_orm(
        belongs_to="super::models::member::Entity",
        from = "Column::DepositorId",
        to = "super::models::member::Column::Id"
    )]
    Depositor,
    #[sea_orm(
        belongs_to="super::models::member::Entity",
        from = "Column::RecorderId",
        to = "super::models::member::Column::Id"
    )]
    Recorder,
}

member.rs
#[derive(Debug, Deserialize, Serialize, Clone, PartialEq, DeriveEntityModel)]
#[sea_orm(table_name="members")]
pub struct Model {
        #[sea_orm(primary_key)]
        pub id: i64,
        pub r#type: MemberType,
        pub name: String,
        pub username: String,
}

#[derive(Debug, Clone, Deserialize, Serialize, DerivePartialModel)]
#[sea_orm(entity = "Entity", from_query_result, into_active_model)]
pub struct Member {
       pub id: i64,
       pub r#type: MemberType,
       pub name: String,
       pub username: String,
}

#[derive(Debug, Clone,  Deserialize, Serialize, PartialEq, Eq, EnumIter, DeriveActiveEnum)]
#[sea_orm(rs_type = "String", db_type = "String(StringLen::N(10))")]
#[serde(rename_all = "lowercase")]
pub enum MemberType {
    #[sea_orm(string_value = "unknow")]
    Unknow,

    #[sea_orm(string_value = "depositor")]
    Depositor,

    #[sea_orm(string_value = "recorder")]
    Recorder,
}

impl IntoActiveValue<MemberType> for MemberType {
    fn into_active_value(self) -> ActiveValue<MemberType> {
        ActiveValue::Set(self)
    }
}

#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
pub enum Relation {
    #[sea_orm(has_many= "super::bill_records::Entity")]
    Depositor,
    #[sea_orm(has_many= "super::bill_records::Entity")]
    Recorder,
}