Column not found with table filter and joins

SelectFilter::make('Has unpaid')
                    ->query(
                        fn (array $data, Builder $query): Builder =>
                        $query->select('persons.*')->when(
                            $data['value'],
                            fn (Builder $query, $value): Builder => $query->leftJoin('transactions', function ($join) use ($data) {
                                $join->on('transactions.person_id', '=', 'person.id')
                                    ->where('transactions.transaction_purpose_id', '=', $data["value"]);
                            })->whereNull('transactions.transaction_purpose_id')
                        )
                    )

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transactions.transaction_purpose_id' in 'where clause'

select
  count(*) as aggregate
from
  `persons`
where
  (`transactions`.`transaction_purpose_id` is null)

select
  `persons`.*
from
  `persons`
  left join `transactions` on `transactions`.`person_id` = `persons`.`id`
  and `transactions`.`transaction_purpose_id` = 3
where
  `transactions`.`transaction_purpose_id` is null;