Cart count error

{
    "title": "mysqli_sql_exception",
    "type": "mysqli_sql_exception",
    "code": 500,
    "message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\nGROUP BY `b`.`goods_created_by`' at line 6",
    "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php",
    "line": 331,
    "trace": [
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php",
            "line": 331,
            "function": "query",
            "class": "mysqli",
            "type": "->",
            "args": [
                "SELECT IFNULL(sum(a.cart_count*b.goods_price), 0) as price, IFNULL(sum(a.cart_count*CEIL((b.goods_price*(b.goods_discount/100)))), 0) as discount, (select shipping_fee from adm000_options) as shipping_fee, IFNULL(sum(a.cart_count), 0) as count, IFNULL(sum(a.cart_count*(b.goods_price-CEIL((b.goods_price*(b.goods_discount/100)))))+(select shipping_fee from adm000_options), 0) as subtotal\nFROM `usr001_cart` `a`\nLEFT JOIN `adm003_goods` `b` ON `a`.`goods_id` = `b`.`goods_id`\nWHERE `a`.`user_id` IS NULL\nAND `a`.`cart_stat` = '2'\nAND `b`.`goods_created_by` = (select goods_created_by from adm003_goods where goods_id=)\nGROUP BY `b`.`goods_created_by`"
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/Database/BaseConnection.php",
            "line": 741,
            "function": "execute",
            "class": "CodeIgniter\\Database\\MySQLi\\Connection",
            "type": "->",
            "args": [
                "SELECT IFNULL(sum(a.cart_count*b.goods_price), 0) as price, IFNULL(sum(a.cart_count*CEIL((b.goods_price*(b.goods_discount/100)))), 0) as discount, (select shipping_fee from adm000_options) as shipping_fee, IFNULL(sum(a.cart_count), 0) as count, IFNULL(sum(a.cart_count*(b.goods_price-CEIL((b.goods_price*(b.goods_discount/100)))))+(select shipping_fee from adm000_options), 0) as subtotal\nFROM `usr001_cart` `a`\nLEFT JOIN `adm003_goods` `b` ON `a`.`goods_id` = `b`.`goods_id`\nWHERE `a`.`user_id` IS NULL\nAND `a`.`cart_stat` = '2'\nAND `b`.`goods_created_by` = (select goods_created_by from adm003_goods where goods_id=)\nGROUP BY `b`.`goods_created_by`"
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/Database/BaseConnection.php",
            "line": 669,
            "function": "simpleQuery",
            "class": "CodeIgniter\\Database\\BaseConnection",
            "type": "->",
            "args": [
                "SELECT IFNULL(sum(a.cart_count*b.goods_price), 0) as price, IFNULL(sum(a.cart_count*CEIL((b.goods_price*(b.goods_discount/100)))), 0) as discount, (select shipping_fee from adm000_options) as shipping_fee, IFNULL(sum(a.cart_count), 0) as count, IFNULL(sum(a.cart_count*(b.goods_price-CEIL((b.goods_price*(b.goods_discount/100)))))+(select shipping_fee from adm000_options), 0) as subtotal\nFROM `usr001_cart` `a`\nLEFT JOIN `adm003_goods` `b` ON `a`.`goods_id` = `b`.`goods_id`\nWHERE `a`.`user_id` IS NULL\nAND `a`.`cart_stat` = '2'\nAND `b`.`goods_created_by` = (select goods_created_by from adm003_goods where goods_id=)\nGROUP BY `b`.`goods_created_by`"
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/Database/BaseBuilder.php",
            "line": 1860,
            "function": "query",
            "class": "CodeIgniter\\Database\\BaseConnection",
            "type": "->",
            "args": [
                "SELECT IFNULL(sum(a.cart_count*b.goods_price), 0) as price, IFNULL(sum(a.cart_count*CEIL((b.goods_price*(b.goods_discount/100)))), 0) as discount, (select shipping_fee from adm000_options) as shipping_fee, IFNULL(sum(a.cart_count), 0) as count, IFNULL(sum(a.cart_count*(b.goods_price-CEIL((b.goods_price*(b.goods_discount/100)))))+(select shipping_fee from adm000_options), 0) as subtotal\nFROM `usr001_cart` `a`\nLEFT JOIN `adm003_goods` `b` ON `a`.`goods_id` = `b`.`goods_id`\nWHERE `a`.`user_id` IS NULL\nAND `a`.`cart_stat` = :a.cart_stat:\nAND `b`.`goods_created_by` = (select goods_created_by from adm003_goods where goods_id=)\nGROUP BY `b`.`goods_created_by`",
                {
                    "a.cart_stat": [
                        "2",
                        true
                    ]
                },
                false
            ]
        },
        {
            "file": "/var/www/html/opoapi/app/Models/CartModel.php",
            "line": 399,
            "function": "get",
            "class": "CodeIgniter\\Database\\BaseBuilder",
            "type": "->",
            "args": []
        },
        {
            "file": "/var/www/html/opoapi/app/Controllers/Api/CartController.php",
            "line": 114,
            "function": "sumStatCheckASeller",
            "class": "App\\Models\\CartModel",
            "type": "->",
            "args": [
                null,
                null
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/CodeIgniter.php",
            "line": 918,
            "function": "countUpdate",
            "class": "App\\Controllers\\Api\\CartController",
            "type": "->",
            "args": [
                "1"
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/CodeIgniter.php",
            "line": 404,
            "function": "runController",
            "class": "CodeIgniter\\CodeIgniter",
            "type": "->",
            "args": [
                {
                    "cart": {
                        "pager": null
                    },
                    "cvm": {
                        "pager": null
                    }
                }
            ]
        },
        {
            "file": "/var/www/html/opoapi/vendor/codeigniter4/framework/system/CodeIgniter.php",
            "line": 312,
            "function": "handleRequest",
            "class": "CodeIgniter\\CodeIgniter",
            "type": "->",
            "args": [
                null,
                {
                    "handler": "file",
                    "backupHandler": "dummy",
                    "storePath": "/var/www/html/opoapi/writable/cache/",
                    "cacheQueryString": false,
                    "prefix": "",
                    "memcached": {
                        "host": "127.0.0.1",
                        "port": 11211,
                        "weight": 1,
                        "raw": false
                    },
                    "redis": {
                        "host": "127.0.0.1",
                        "password": null,
                        "port": 6379,
                        "timeout": 0,
                        "database": 0
                    },
                    "validHandlers": {
                        "dummy": "CodeIgniter\\Cache\\Handlers\\DummyHandler",
                        "file": "CodeIgniter\\Cache\\Handlers\\FileHandler",
                        "memcached": "CodeIgniter\\Cache\\Handlers\\MemcachedHandler",
                        "predis": "CodeIgniter\\Cache\\Handlers\\PredisHandler",
                        "redis": "CodeIgniter\\Cache\\Handlers\\RedisHandler",
                        "wincache": "CodeIgniter\\Cache\\Handlers\\WincacheHandler"
                    }
                },
                false
            ]
        },
        {
            "file": "/var/www/html/opoapi/public/index.php",
            "line": 52,
            "function": "run",
            "class": "CodeIgniter\\CodeIgniter",
            "type": "->",
            "args": []
        }
    ]
}