How did i do this mutiple join

[joebnb]

       let query_builder = model::comments::Entity::find()
            .select_only()
            .column(model::comments::Column::Id)
            .column(model::comments::Column::Content)
            .column(model::comments::Column::CreateTime)
            .column(model::comments::Column::UserId)
            .column(model::comments::Column::TargetId)
            .column(model::comments::Column::TargetType)
            .filter(condition)
            .pagination(current_page, page_size);

      let reply_to_user_alias = Alias::new("reply_to_user");

      let list: Vec<CommentListItem> = query_builder
          .column_as(model::user::Column::NickName, "user_nickname")
          .column_as(model::user::Column::Id, "user_id")
          .column_as(model::user::Column::Avatar, "user_avatar")
          .join(
              sea_orm::JoinType::LeftJoin,
              model::comments::Relation::User.def(),
          )
          .join_as(
              sea_orm::JoinType::LeftJoin,
              model::comments::Relation::ReplyToUser.def(),
              reply_to_user_alias.clone(),
          )
          .column_as(model::user::Column::NickName, "user_nickname")
          .column_as(model::user::Column::NickName, "reply_to_user_nickname")
          .column_as(model::user::Column::Id, "reply_to_user_id")
          .into_model()
          .all(db_conn)
          .await?;

in upper there will join user twice from user_id and reply_to_user_id, current it seems print user and reply_user are same column(id,nickname and avatar),it's not expect, where i did wrong? is there column_as have some function like #2133 from_alias?

btw: there are too many disscuss about join mutiple, if there have a well documented by official i think it's good for architecture evolution

[joebnb]

This software is excellent, but it's been evolving for several years now. I imagine the maintainers have probably come up with better ideas than the original design during the development process. I'm wondering if there's any plan to gradually refactor the project over time.

If the APIs become more convenient to use, I’d be happy to follow along and upgrade incrementally.
Alternatively, introducing new APIs with the same functionality (while marking the old ones as deprecated) would also work well, giving everyone more time to migrate smoothly.

[Expurple]

If the APIs become more convenient to use, I’d be happy to follow along and upgrade incrementally.

Since this month, you can use "reply_to_user" directly instead of wrapping it in Alias::new("reply_to_user")

[Huliiiiii]

You didn't specify which join the following columns come from.

.column_as(
  Expr::col((reply_to_user_alias.clone(), model::user::Column::NickName)),
  "reply_to_user_nickname"
)

[joebnb]

thanks,but how did you konw this method to do this ? i want know the learning path

[Huliiiiii]

Sorry I forgot that.