Александр Измайлов

$regex = '/php÷([^¬]*)/';
preg_match_all($regex, $text, $array);
$i = $array[1]; //1 индекс это первая группа, 0 индекс это вся выборка
print_r($i);

['surname', 'on' => ['register', 'create', 'update']]

foreach($tags as $tag) {
    $conditions[] = ['like', 'tags', $tag];
}
$query->andFilterWhere(array_merge(['or'], $conditions));

SELECT users.* FROM users
LEFT JOIN blacklist bl ON bl.objectID = users.id AND bl.userID = 93
LEFT JOIN blacklist bl2 ON bl2.userID = users.id AND bl2.objectID = 93
WHERE bl.id IS NULL AND bl2.id IS NULL

SELECT users.* FROM users
LEFT JOIN blacklist ON blacklist.userID = users.id OR blacklist.objectID = users.id
WHERE blacklist.userID IS NULL