Handle aggregate functions in JOIN conditions

[Jumail]

Hi, I'm new to sea-orm and I ran into the following problem. I have two tables user and user_position with one to many relationship.

I would like to select user with the latest user_position for each user. This was my approach:

let results = user::Entity::find()
        .join(
            JoinType::LeftJoin,
            user::Relation::UserPosition
                .def()
                .on_condition(|_left, right| {
                    Expr::col((right, user_position::Column::ReportTime))
                        .max()
                        .into_condition()
                }),
        )
        .all(context.conn())
        .await?;

I quickly realised that aggregate functions are not allowed in JOIN conditions as per the error returned:

Query Error: error returned from database: aggregate functions are not allowed in JOIN conditions

How would I fix this query?

Thanks in advance.