Invalid parameter number using raw query, BUT THE CORRECT # OF PARAMS ARE BOUND

Lookup usage of the IN operator.

Edit:

You can also work it out in an if statement. Or prior to the query figure out which one.

Also check the docs I think there is an orWhere clause.

I guess duplicate placeholders don't work in the query builder. With straight PDO your idea should work.

You can bind the same parameter twice with a different placeholder name. You can also omit colons from the placeholder names when binding values:

$count = MyModel::whereRaw('status_id_one = :id1 OR status_id_two = :id2', [
	'id1' => $statusId, 
	'id2' => $statusId, 
])->count();

But there's no reason to use whereRaw here:

$count = MyModel::where('status_id_one', $statusId)
			->orWhere('status_id_two', $statusId)
			->count();