when i add a where clause on a withCount it send error

"SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous (SQL: select `id`, `full_name`, (select count(*) from `student_assignments` inner join `enrollments` on `enrollments`.`id` = `student_assignments`.`enrollment_id` where `students`.`id` = `enrollments`.`student_id` and `status` = 1) as `assignments_count`, (select count(*) from `student_assignments` inner join `enrollments` on `enrollments`.`id` = `student_assignments`.`enrollment_id` where `students`.`id` = `enrollments`.`student_id`) as `Total` from `students` limit 100)",

This is my query.

$this->model
            ::query()
            ->select(['id', 'full_name'])
            ->withCount([
                'assignments' => function ($query) {
                    $query->where(
                        'status',
                        '=',
                        StudentAssignment::STATUS_ACTIVE
                    );
                },
                'assignments as Submitted' => function (Builder $query) {
                    $query->where(
                        'status',
                        '=',
                        StudentAssignment::STATUS_SUBMITTED
                    );
                },
                'assignments as Total'
            ])
            ->limit($limit)
            ->orderByDesc('Pending')
            ->get();

if remove this from withCount() it will work.

				'assignments as Pending' => function ($query) {
                    $query->where(
                        'status',
                        '=',
                        StudentAssignment::STATUS_ACTIVE
                    );
                },
                'assignments as Submitted' => function (Builder $query) {
                    $query->where(
                        'status',
                        '=',
                        StudentAssignment::STATUS_SUBMITTED
                    );
                },